Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [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]Fundamentals
   [Expand]Binding to Data
   [Collapse]Data Shaping
    [Expand]Summarization
     Grouping
    [Expand]Sorting
    [Collapse]Filtering
     [Expand]Filtering Basics
      Group Filtering
      Prefilter
     [Collapse]Filtering by Summaries
       Filtering by Summaries Overview
       Using Summary Filters
    [Expand]Editing
     Data Formatting
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-time Features
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [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]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

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.

Note

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

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