Using Filter Popup Windows

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

ExpandedCollapsed Simple Filter Window

A simple Filter Window allows you to hide visible and show previously hidden values of a particular field.

img16180

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.

ExpandedCollapsed Hierarchical Filter Window

A hierarchical Filter Window displays values of several fields, arranged in a tree-like manner.

img16181

In the Filter Window, uncheck field values that should be hidden and check values that should be visible.

Use the img16184 buttons to expand field values and access their child values. To collapse an expanded field value and hide its child values, use the img16183 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.

img16229

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.

ExpandedCollapsed Filtering Indication

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.

img7616

ExpandedCollapsed Removing Filtering

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.