Summary Filter Popup Window
- 3 minutes to read
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 a detail 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 a detail 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.
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.
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.