[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
   [Collapse]Data Shaping
      Filtering Overview
      Group Filtering
     [Collapse]Filtering by Summaries
       Filtering by Summaries Overview
       Using Summary Filters
     [Expand]OLAP Filtering Specifics
     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]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 by Summaries Overview

PivotGridControl allows you to filter data by summary values. You can specify a range of values to be displayed for each Data Field. Summary values that do not fall into this range will not be shown in the pivot grid nor will they take part in any calculations.


Filtering by Summaries is not supported in OLAP mode.

This topic describes specific aspects related to filtering by summaries. To learn how to enable and configure this feature, see Using Summary Filters.

Expanded Target Cells

Summary filtering cannot be simultaneously enabled for Totals, Grand Totals and data cells calculated against the same data field. It can only be applied to cells that belong to the same data aggregation level.

Summary filtering is applied to cells that belong to the last level by default (a level identified by the last column and row fields). You can specify other levels, except for the (Grand Total, Grand Total) level, which consists of only one cell.

Note that this does not apply to cells calculated against different data fields. You are free to apply summary filtering to Totals calculated against a specific data field, as well as data cells calculated against another data field.

Expanded Order of Applying

Summary filters are applied after standard filters, group filters and the Prefilter. This does not depend on whether a summary filter has been activated before or after these filters.

Summary filters configured for different data fields are applied simultaneously.

For instance, consider a summary filter that is applied to the last-level cells of a certain data field. Specific summary cells are hidden as a result of filtering, which leads to the recalculation of Totals for all data fields.

Now, if you open a summary filter popup to apply filtering to Totals, you will see a summary distribution diagram that shows old Total values, without taking into account the effect of the first summary filter.

This is the intended behavior, since the second summary filter will actually be applied to the initial data simultaneously to the first filter.

Expanded Limitations

Filtering by summaries is not available if any of the following features are used:

Filtering by summaries has the following limitations:

  • Filtering by summaries is available for numeric data fields only.
  • Filtering by summaries does not affect custom totals.
  • A summary filter is reset when a data field's summary type (PivotGridFieldBase.SummaryType) is changed.

Expanded See Also

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