Log In
[Expand]General Information
[Collapse]WinForms Controls
 [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
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Collapse]Data Shaping
     [Collapse]Filtering Basics
       End-User Filtering
       Filtering in Code
       OLAP Filtering Specifics
      Group Filtering
     [Expand]Filtering by Summaries
     Data Formatting
   [Expand]Data Analysis
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Design-time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [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]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]Document Server
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

End-User Filtering

End-users can apply, change or remove filtering on a field using the filter drop-down invoked by clicking a field's filter button.

The filter drop-down contains unique values stored in a corresponding field of the underlying data source. These values can be obtained using the PivotGridFieldBase.GetUniqueValues method.


End-users cannot change filtering applied to fields located within Data Header Area.

Expanded Availability

You can prevent end-users from applying or changing filtering at runtime by hiding filter buttons from the field headers.

To hide filter buttons from all field headers, set the PivotGridOptionsCustomization.AllowFilter property to false. You can also do this for individual fields using their PivotGridFieldOptions.AllowFilter properties.

Note that this does not affect the filtering in code.

Expanded Filter Drop-Down Toolbar

Filter drop-down lists display a toolbar that allows end-users to control various filtering options.

To learn more about the toolbar functionality, see Filter Button and Drop-Down.

Expanded Radio Mode

The Pivot Grid Control allows you to hide check boxes from filter drop-downs, displaying filter items as a simple list (Radio Mode). In this instance, end-users can select only one item from a filter drop-down.

To enable a Radio Mode for all fields, set the PivotGridOptionsFilterPopup.IsRadioMode property to true. To do this for individual fields, use their PivotGridFieldOptionsEx.IsFilterRadioMode properties.

End-users can enable or disable the Radio Mode with the toolbar button.

Expanded Displaying Only Available Filter Items

By default, a filter drop-down window invoked for a particular field contains unique field values, although some of these values may actually be excluded from the pivot grid by applying filtering to other fields.

Presume that a pivot grid contains two dimension fields: Category Name and Product Name.

If you choose only one product category from the Category Name filter drop-down, all products related to other categories will be excluded from the pivot grid. This means that whether you check or uncheck any of these products in the Product Name filter drop-down, this will have no effect, since they are hidden by the category filtering.

The Pivot Grid Control allows you to remove such field values from filter drop-downs. To do this, set the PivotGridOptionsFilterBase.ShowOnlyAvailableItems property to true.

The image below illustrates the property effect.

End-users can enable or disable the ShowOnlyAvailableItems option using the toolbar button.

Expanded See Also

How would you rate this topic?​​​​​​​