PivotGridField.FilterType Property
Gets or sets a field’s filter type.
Namespace: DevExpress.Xpf.PivotGrid
Assembly: DevExpress.Xpf.PivotGrid.v24.2.dll
NuGet Package: DevExpress.Wpf.PivotGrid
#Declaration
public FieldFilterType FilterType { get; set; }
#Property Value
Type | Description |
---|---|
Field |
A Field |
Available values:
Name | Description |
---|---|
Excluded | Specifies that the DXPivot |
Included | Specifies that the DXPivot |
#Remarks
If the FilterType property is set to Included, only the data source records that correspond to one of the filter values will be processed. Otherwise, the PivotGrid control will processes only the data source records that do not correspond to any filter value.
The following example shows how to filter the Category field by the “Produce” and “Seafood” values. For this, add these values to the PivotGridField.FieldFilterValues collection and set a filter type using the FilterType property.
public MainWindow() {
List<object> filterValues = new List<object>();
filterValues.Add("Produce");
filterValues.Add("Seafood");
fieldCategory.FilterType = DevExpress.Xpf.PivotGrid.FieldFilterType.Included;
fieldCategory.FieldFilterValues = filterValues;
}