<< 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):
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.
After you have built and applied a filter condition, a prefilter panel appears at the Pivot Table bottom. This panel displays the filter condition.
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 button.
To remove filtering, click the 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.
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.