The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotFilterCollection Interface

A collection of filters applied to the PivotTable fields.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

public interface PivotFilterCollection :
    ISimpleCollection<PivotFilter>,
    IEnumerable<PivotFilter>,
    IEnumerable,
    ICollection
Public Interface PivotFilterCollection
    Inherits ISimpleCollection(Of PivotFilter),
             IEnumerable(Of PivotFilter),
             IEnumerable,
             ICollection
public interface PivotFilterCollection :
    ISimpleCollection<PivotFilter>,
    IEnumerable<PivotFilter>,
    IEnumerable,
    ICollection
Public Interface PivotFilterCollection
    Inherits ISimpleCollection(Of PivotFilter),
             IEnumerable(Of PivotFilter),
             IEnumerable,
             ICollection

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