PivotGridFieldFilterValues.InvertFilterType() Method

Inverts the current filter type.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v18.2.Core.dll

Declaration

C#

public void InvertFilterType()

VB.NET

Public Sub InvertFilterType

Remarks

The InvertFilterType method does the following:

• If the PivotGridFieldFilterValues.FilterType property is set to PivotFilterType.Included, the InvertFilterType method sets it to PivotFilterType.Excluded, and vice versa.
• Inverts the PivotGridFieldFilterValues.Values collection (i.e., clears and populates it with field values that were not contained in it previously). This preserves the actual filter condition.

You can also use the PivotGridFieldFilterValues.SetFilterType method to specify the filter type.

To set the filter type without changing the PivotGridFieldFilterValues.Values collection, use the PivotGridFieldFilterValues.FilterType property. Note that this will invert the filter condition.