<< 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.
Use the toolbar buttons to enable or disable particular options.
The following table describes the available toolbar buttons.
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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.