PivotFilterCollection Interface

A collection of filters applied to the PivotTable fields.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

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

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.

See Also

PivotFilterCollection Members

WinForms Spreadsheet Control Examples

DevExpress.Spreadsheet Namespace