Build Complex Filter Criteria

<< Click to Display Table of Contents >>

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

Build Complex Filter Criteria

Interface Elements for Desktop > Pivot Table > Data Presentation > Filter Data in Pivot Tables > Build Complex Filter Criteria

To build complex filter criteria consisting of multiple filter clauses using various filter operators, you can use a Prefilter (Filter Editor):

img7617

The Prefilter does not affect filtering via Filter Popup Windows.

To invoke a Prefilter, click an empty space within the Pivot Table header region and select Show Prefilter from the context menu.

img7594

After you have built and applied a filter condition, a prefilter panel appears at the Pivot Table bottom. This panel displays the filter condition.

img13154

To modify a filter condition, open a Prefilter. You can now do it by clicking the Edit Prefilter button.

To temporarily disable filtering, uncheck the img7619 button.

To remove filtering, click the img7620 button.

For information on the Prefilter filtering capabilities, see Filter Data via the Filter Editor. To learn how to create filter criteria using a Prefilter, please see Examples of Using the Filter Editor.

ExpandedCollapsed See Also

Filter Data via the Filter Editor

Examples of Using the Filter Editor

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

Send Feedback on this topic to DevExpress.