Filter Button and Dropdown
Filter buttons are displayed within field headers and can be clicked to invoke the filter dropdown. This window allows end-users to filter the data by selecting the field values which will be included in the resulting data subset to calculate summaries. Check boxes for field values that are currently filtered out are grayed. These values cannot be used for filtering.
The table below lists the main properties which affect the appearance and behavior of the filter button and dropdown window.
Visibility | A field’s Options.Filtering property. This option can be overridden by the pivot grid’s OptionsCustomize.Filtering property. |
Custom Draw Event | The pivot grid’s OnCustomDrawFieldHeader event. |
Filter Criteria | A field’s Filter property. |
Behavior | The pivot grid’s OptionsCustomize.FilterResizable property. A field’s Options.FilteringPopupIncrementalFiltering property. |
Size | The pivot grid’s OptionsView.FilterDropDownMaxItemCount and OptionsView.FilterDropDownWidth properties. |
Context Menu | Refer to the Field Header Context Menu topic. |
HitTest Information | The HitTest.HitAtButton property. |