Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Filtering

The following table shows how end-users can filter data in the ExpressPivotGrid control. Data can be filtered against any fieldsdata, 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.