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
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-time Features
   [Expand]Miscellaneous
   [Collapse]UI Elements
     Cell
     Field Value
     Row Field
     Column Field
     Data Field
     Filter Field
     Field Header
     Data Area
     Header Area
     Data Header Area
     Row Header Area
     Column Header Area
     Filter Header Area
     Empty Area
     Totals
     Grand Totals
     Prefilter Panel
     Summary Filter Popup Window
     Field Header Context Menu
     Field Value Context Menu
     Header Area Context Menu
     Data Field Summary Change Menu
     Expand Button
     Filter Button and Drop-Down
     Filter Header Area Separator
   [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

Summary Filter Popup Window

The summary filter popup window allows end-users to select a range of summary values that should be displayed in the pivot grid. This window is invoked when an end-user clicks the filter button displayed within the header of a data field.

The summary filter popup contains the following visual elements.

  • Start Value and End Value text editors - allow end-users to enter bounds of the selected range from a keyboard.
  • Range Selector - used to select a range via pointing. For more information, see the Range Selector section below.
  • Apply to Specific Level check box - if checked, enables the Column Field and Row Field combo boxes. In this instance, an end-user can select an aggregation level to which the filtering will be applied.
  • Column Field and Row Field combo boxes - allow end-users to select a column and row field that identify an aggregation level to which the filtering will be applied. Enabled if the Apply to Specific Level check box is checked.
  • Clear button - resets the summary filter.

Expanded Range Selector

Use the Range Selector to select a range of summary values that should be displayed in the pivot grid.

The Range Selector consists of the following elements.

  • Summary Distribution Diagram - shows the distribution of summary values. See the Summary Distribution Diagram section below to learn more.
  • Selection Thumbs - drag to select the range between thumbs.
  • Viewport Scroll Thumb - drag to move the viewport.
  • Zoom Grips - use to enlarge or shrink the viewport.
  • Selection Scroll Thumb - drag to move the selection.

Expanded Summary Distribution Diagram

The Summary Distribution Diagram displays the distribution of summary values and indicates which values are already filtered out.

The horizontal axis shows numeric values. They can be decimal or integer, depending on the data type of summary values. By default, the minimum and maximum values on this axis match the smallest and largest summary values respectively.

The diagram displays bars, whose bases break the horizontal axis into a number of even ranges. The height of each bar indicates the number of summary values that fall into the corresponding range.

Dark blue bar regions correspond to visible summary values, while light blue regions correspond to hidden values.

In addition, the diagram displays two constant lines. The first one indicates the maximum number of summary values that fall into one range (the height of the highest bar). The second one indicates the same number among the visible values (the height of the highest dark blue bar).

Note

If summary values are integers, and their minimum and maximum values are close enough, so that no more than one value falls into each range, the diagram displays pins instead of bars. In this instance, selection thumbs snap to these pins.

Expanded See Also

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