Field values in the PivotGrid control can be filtered. The FieldFilterValues.FilterType property of the FieldFilterType class specifies a field's filter type.
A field's PivotGridField.FilterValues collection contains filter values. If the FieldFilterValues.FilterType property is set to Included, only the records which contain values from the Values array of a specific field are displayed by the PivotGrid control. Otherwise, if the FieldFilterValues.FilterType property is set to the Excluded value, only the records which don't contain values from the Values array of a specific field are displayed.