[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Collapse]End-User Capabilities
     Controlling the Visibility of Fields
     Editing Unbound Expression
     Reordering Fields
     Resizing Columns
     Navigating Through Cells
     Selecting Cells
     Expanding and Collapsing Grouping Columns and Rows
      Filtering Against Dimension Fields
     [Expand]Filtering by Summary Values
     Changing Summary Type
     Applying Conditional Formatting
     Data Editing
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Filtering Against Dimension Fields

End users can use a field's filter popup to apply a filter criteria to a field and a filter editor to apply it to the entire control. The Pivot Grid supports two types of filtering: Excel-style and Classic. Default type is Excel-style.

Expanded Filter Popup

The filter popup allows end-users to filter column, row, or filter fields.

To apply filtering to a field, click the filter button in the field header and select the field values that should be displayed in the pivot grid.

The Excel-style filter popup's content depends on the type of data the related field displays. In the "Values" tab, end users can select specific field values from the Pivot Grid. The "Filters" tab supplies users with additional options related to the field type. For example, when filtering a string field, you can show only those records that begin with 'C':

The Excel-style filter popup displays applied filters in the popup and the Filter panels. The Filter Editor dialog allows end user to create and edit complex filter conditions.


The Excel-style cannot be used in the following cases: to apply filtering in OLAP mode.

The Classic filter popup allows to filter only field values. The filter values specified by the Classic style filter are not displayed in the Filter Panel. End users can use toolbar buttons to control filtering options. To learn more about the toolbar functionality, see Filter Button and Popup.

API Description
PivotGridFieldOptionsEx.FieldFilterPopupMode Gets or sets the field's filter popup mode.
PivotGridFieldOptions.AllowFilter Gets or sets whether an end-user can apply a filter to the current field.

Expanded Filter Editor

The Filter Editor allows you to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators, and applies filters to the entire control.

To invoke the Filter at runtime, right-click a field header area or a field header, and choose 'Show Filter' from the context menu.

API Description
WindowsFormsSettings.FilterCriteriaDisplayStyle Gets or sets the default display style of filter conditions in a control's Filter Panel and built-in Filter Editor.
PivotGridOptionsCustomization.AllowFilter Gets or sets whether filter buttons are displayed within field headers.

Expanded Filter Panel

Once the Filter has been applied, the Pivot Grid Control shows the <b>Filter Panel</b> at the bottom.

The following capabilities are available for end users:

  • Close Filter button that closes the panel and clears the filter
  • Enable Filter checkbox to temporarily disable or enable the current filter.
  • MRU Filter button that displays the MRU (most recently used) Filter List.
  • Edit Filter button that invokes the Filter Editor to build complex filter criteria.

The MRU list is not available if the filter criteria display style is Visual (the WindowsFormsSettings.FilterCriteriaDisplayStyle property value equals Visual).

Expanded See Also

Is this topic helpful?​​​​​​​