Filtering Summary Fields

media_1450350613943.png

Click a filter button displayed in the header of a data field to invoke the Summary Filter Popup.

media_1450350679830.png

The summary filter popup window allows end-users to select a range of summary values that should be displayed in the pivot grid.

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.

media_1450350751510.png

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

Summary Distribution Diagram – shows the distribution of summary values.
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.

media_1450350820133.png

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).