Filtering Options

<< Click to Display Table of Contents >>

Navigation:  User Interface Reference > Pivot Table / Analyzer > Data Presentation > Filter Data > Filter Data by Field Values >

Filtering Options

Interface Elements for Desktop > Pivot Table > Data Presentation > Filter Data in Pivot Tables > Filter Data by Field Values > Filtering Options

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.

img15547

Use the toolbar buttons to enable or disable particular options.

The following table describes the available toolbar buttons.

img15602

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.

This button is not available for Hierarchical Filter Windows.

img15597

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.

img15598

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.

img15600

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.

img15601

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.

img15599

Invert Filter

Inverts the checked state for all values.

Copyright (c) 1998-2016 Developer Express Inc. All rights reserved.

Send Feedback on this topic to DevExpress.