PivotFilterCollection Interface

A collection of filters applied to the PivotTable fields.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

public interface PivotFilterCollection :
    ISimpleCollection<PivotFilter>,
    IEnumerable<PivotFilter>,
    IEnumerable,
    ICollection

VB.NET

Public Interface PivotFilterCollection
    Inherits ISimpleCollection(Of PivotFilter),
             IEnumerable(Of PivotFilter),
             IEnumerable,
             ICollection

Related API Members

The following members return PivotFilterCollection objects:

• PivotTable.Filters

Remarks

Use the PivotTable.Filters property to get access to the PivotFilterCollection collection. To add a new filter to a specific row or column field in the PivotTable report, use the PivotFilterCollection.Add method overloads.

To remove a filter from the collection, use the PivotFilterCollection.Remove or PivotFilterCollection.RemoveAt method.

To clear all filters applied to the PivotTable fields, call the PivotFilterCollection.Clear method.