<< Click to Display Table of Contents >> Navigation: User Interface Reference > Pivot Table / Analyzer > Data Presentation > Filter Data > Filter Data by Field Values > Using Filter Popup Windows |
Interface Elements for Desktop > Pivot Table > Data Presentation > Filter Data in Pivot Tables > Filter Data by Field Values > Using Filter Popup Windows
Depending on the settings made by your application vendor, the Pivot Table can display an individual Filter Window for each field, or an integrated Filter Window for a group of fields.
This topic describes how to filter data using both types of Filter Windows.
A simple Filter Window allows you to hide visible and show previously hidden values of a particular field.
In the Filter Window, uncheck field values that should be hidden and check values that should be visible. Then, click OK to close the window and apply the filtering.
Note that you can customize Filter Window settings using the toolbar displayed at the top of the window. To learn how to do this, see Filtering Options.
A hierarchical Filter Window displays values of several fields, arranged in a tree-like manner.
In the Filter Window, uncheck field values that should be hidden and check values that should be visible.
Use the buttons to expand field values and access their child values. To collapse an expanded field value and hide its child values, use the button.
You can also expand and collapse all values on a particular level. To do this, right-click any field value and select Collapse All or Expand All from the context menu.
For instance, to expand all quarters and display months, right-click any quarter value and select Expand All from the context menu as shown on the image below.
Click OK to close the window and apply the filtering.
Note that you can customize Filter Window settings using the toolbar displayed at the top of the window. To learn how to do this, see Filtering Options.
You can determine whether a field is filtered by looking at its header. Filter buttons for these fields are visible even when you are not hovering over their headers.
To remove filtering against a specific field, invoke its Filter Window and select (Show All).
Copyright (c) 1998-2016 Developer Express Inc. All rights reserved.
Send Feedback on this topic to DevExpress.