Filtering

Filter Data

To apply filtering to a field, click the filter button in the field header and select field values that should be displayed in the pivot grid:

EUC_Filtering_FilterButton

The filter drop-down, invoked for fields arranged into a group, has a tree-like interface which allows you to manipulate the values of all fields in the group via a single drop-down:

EUC_Filtering_FilterGroup

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:

EUC_Filtering_ShowPrefilter

Once the Prefilter has been applied, the PivotGridControl shows the Prefilter Panel at the bottom:

EUC_Filtering_PrefilterPanel

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

Note