[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Chart Control
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Collapse]End-User Capabilities
     Expanding and Collapsing Grouping Columns and Rows
     Controlling the Visibility of Fields
     Reordering Fields
   [Expand]Member Tables
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[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]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation


Expanded Filter Data

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

The filter drop-down, invoked for fields arranged into a group, has a tree-like interface which allows you to manipulate the values of all fields in the group via a single drop-down:

Expanded Prefilter

The Prefilter allows you to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators. To invoke the Prefilter at runtime, right-click a field header area or a field header, and choose 'Show Prefilter' from the context menu:

Once the Prefilter has been applied, the PivotGridControl shows the Prefilter Panel at the bottom:

To enable/disable the Prefilter, use the check box in the Prefilter Panel.


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