Filtering
The following table shows how end-users can filter data in the ExpressPivotGrid control. Data can be filtered against any fields – data, column, row, and filter fields.
Action | Effect |
|---|---|
Clicking the ‘Show Prefilter Dialog‘ item in the header area context menu. | Invokes the filter builder dialog. |
Clicking prefilter panel elements. | Enables, disables, or clears the currently applied filter. Selects a prefilter from the MRU list. Invokes the filter builder dialog to customize the currently applied prefilter criteria. |
Clicking the filter button and selecting items in the filter dropdown that is invoked as a result. | Displays the selected items in the current field. The items that are not selected are hidden in the control and are not used in calculating summaries. |
Note:
Use the pivot grid’s OptionsPrefilter property to specify the visibility of the prefilter panel and its elements.
Use the pivot grid’s OptionsCustomize.QuickPrefiltering property to enable or disable the ‘Show Prefilter Dialog‘ menu item.
Use the pivot grid’s OptionsCustomize.Filtering property to prevent end-users from filtering data against all the fields.
Use a field’s Options.Filtering property to prevent end-users from filtering data against a specific field.