vcl-157125-expresspivotgrid-end-user-capabilities-filtering.md
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.
|
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.