Filtering Dimension Fields

Filter Data


To apply filtering to a field, click the filter button in the field header and select the field values that should be displayed in the Pivot Form.



The Prefilter allows you to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators.


Right click a field header area or a field header, and choose ‘Show Prefilter’ from the context menu.


Once the Prefilter has been applied, the Pivot Grid Control shows the Prefilter Panel at the bottom.

To disable/enable the Prefilter, use the check box in the Prefilter Panel.

To edit the Prefilter, use the Edit Prefilter button.