Filtering Against Dimension Fields

• Apr 01, 2018

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 grid.

Prefilter

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

To invoke the Prefilter at runtime, 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.

Note

• Use the control’s PivotGridOptionsCustomization.AllowFilter property to prevent end-users from filtering data against all fields.
• Use a field’s PivotGridFieldOptions.AllowFilter property to prevent end-users from filtering data against a specific field.