PivotPageFieldCollection Interface

Represents a collection of fields located in the report filter area of a pivot table.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public interface PivotPageFieldCollection :
    ISimpleCollection<PivotPageField>,
    IEnumerable<PivotPageField>,
    IEnumerable,
    ICollection

VB.NET

Public Interface PivotPageFieldCollection
    Inherits ISimpleCollection(Of PivotPageField),
             IEnumerable(Of PivotPageField),
             IEnumerable,
             ICollection

Related API Members

The following members return PivotPageFieldCollection objects:

• PivotTable.PageFields

Remarks

The PivotPageFieldCollection object stores all page fields added to a PivotTable report. Use the PivotTable.PageFields property to access this collection. The PivotPageFieldCollection.Item property enables you to get an individual page field by its name or index in the collection.

To add a page field to the pivot table, use the PivotPageFieldCollection.Add or PivotPageFieldCollection.Insert method. To remove a page field from the PivotTable report, use the PivotPageFieldCollection.Remove or PivotPageFieldCollection.RemoveAt method.