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