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:
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.
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:
To learn how to use the Prefilter, see Filter Editor.
Once the Prefilter has been applied, the PivotGridControl shows the Prefilter Panel at the bottom:
To disable/enable the Prefilter, use the check box on the Prefilter Panel:
When the Panel is shown, the Prefilter can also be invoked by clicking the 
button. To clear the Prefilter, click the 
button.