Field values in the XtraPivotGrid control can be filtered. The PivotGridFieldFilterValues.FilterType property of the PivotFilterType class specifies a field's filter type.
A field's PivotGridFieldFilterValues.Values collection contain filter values. If the FilterType property is set to Included, only the records which contain values from the Values array of a specific field are displayed by the XtraPivotGrid control. If the FilterType property is set to Excluded, only the records which don't contain values from the Values array of a specific field are displayed.