PivotFilterType Enum

Contains the values that specify a field’s filter type in the XtraPivotGrid control.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v23.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design

Declaration

C#

public enum PivotFilterType

VB.NET

Public Enum PivotFilterType

Members

Name	Description
Excluded	Specifies that the XtraPivotGrid control should not display the filter values. All the other values will be displayed.
Included	Specifies that the XtraPivotGrid control should display only the filter values.

Related API Members

The following properties accept/return PivotFilterType values:

Library	Related API Members
Cross-Platform Class Library	PivotGridFieldFilterValues.FilterType
	PivotGroupFilterValues.FilterType
WinForms Controls	PivotFieldFilterChangingEventArgs.FilterType
ASP.NET Web Forms Controls	PivotFieldFilterChangingEventArgs.FilterType

Remarks

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.