GroupFilterValues.FilterType Property

Gets or sets the filter type.

Namespace : DevExpress.Xpf.PivotGrid

Assembly : DevExpress.Xpf.PivotGrid.v25.2.dll

NuGet Package : DevExpress.Wpf.PivotGrid

Declaration

C#
VB.NET

csharp

public FieldFilterType FilterType { get; set; }

Public Property FilterType As FieldFilterType

Property Value

Type	Description
FieldFilterType

A FieldFilterType enumeration member that specifies the filter type.

Available values:

Name	Description
Excluded

Specifies that the DXPivotGrid control should not display the filter values. All the other values will be displayed.

| | Included |

Specifies that the DXPivotGrid control should display only the filter values.

Remarks

If the FilterType property is set to FieldFilterType.Included, only data source records that correspond to one of the filter values (stored within the PivotGroupFilterValues.Values collection) are processed. Otherwise, if the FilterType property is set to FieldFilterType.Excluded, only data source records that do not correspond to any filter value are processed.

A group filter value corresponds to a data source record if the following conditions are met:

The data source record contains the group filter value in the respective field.
The data source record contains the group filter value’s parent values in the respective fields.
The group filter value does not contain child values.

See Group Filtering for details.

Note

The FilterType property is not in effect when you set filter values in the Excel-style pop-up filter.