<< Click to Display Table of Contents >>

 

The Pivot Table allows you to customize its filtering mechanism according to your needs.

If the corresponding functionality is enabled by your application vendor, Filter Windows display toolbars where you can access various filtering options.

VisualElements_FilterDropdown_Toolbar

Use the toolbar buttons to enable or disable particular options.

The following table describes the available toolbar buttons.

Icon

Button Tooltip

Description

Toolbar_ShowOnlyAvailableItems

Show Only Available Items

If this button is pressed, values that cannot be displayed because of filtering applied to other fields are hidden from Filter Windows. Note that this button is not available for Hierarchical Filter Windows.

Toolbar_FilterType

Show New Field Values

If this button is pressed, field values that have appeared in the database after the field's filtering was configured are shown by default. If this button is released, new field values are hidden by default. To view these values, check them manually in the corresponding Filter Window.

Toolbar_IncrementalSearch

Incremental Search

If this button is pressed, the Incremental Search feature is enabled. This feature allows you to locate a value in the Filter Window by typing its initial characters.

Toolbar_MultiSelection

Multi-Selection

If this button is pressed, you can select multiple values by sequentially clicking them with the CTRL key held down (or the SHIFT key to select a continuous range of values). In this instance, a field value is selected when you click its name, and checked (or unchecked) when you click a corresponding check box. When you click a check box with multiple values selected, this changes the checked state of all selected values. If this button is released, you cannot select multiple values. In this instance, a field value is selected and checked (or unchecked) when you click either its name or a corresponding check box.

Toolbar_RadioMode

Radio Mode

If this button is pressed, Filter Windows hide check boxes and display field values in a simple list. In this instance, you can select and view only one value from each field in the Pivot Table.

Toolbar_InvertFilter

Invert Filter

Inverts the checked state for all values.