Filtering Dimension Fields

Filter Data

media_1450350441382.png

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.

Prefilter

media_1450350475032.png

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

media_1450350497646.png

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

media_1450350524587.png

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.