<< Click to Display Table of Contents >>

 

Use a Filter Editor to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators.

EU_XtraPivotGrid_Filter

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

EU_XtraPivotGrid_ShowFieldListMenu

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

pivotgrid_FilterPanel

Click the Edit Filter button to invoke the Filter Editor and modify a filter condition.

To temporarily disable filtering, uncheck the EU_XtraPivotGrid_FilterPanel_EnableButton button.

To remove filtering, click the EU_XtraPivotGrid_FilterPanel_CloseButton button.

See also:

Filter Data via the Filter Editor

Examples of Using the Filter Editor