Skip to main content
Row

PivotItemCollection Interface

Represents a collection of PivotItem objects in a PivotTable field.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

public interface PivotItemCollection :
    ISimpleCollection<PivotItem>,
    IEnumerable<PivotItem>,
    IEnumerable,
    ICollection

The following members return PivotItemCollection objects:

Remarks

When you create a pivot table, the PivotItemCollection collection is populated automatically with the unique data entries retrieved for each field from the source data. To return a collection of items contained in a specific PivotTable field, use the PivotField.Items property. An individual PivotItem object can be accessed by its index in the collection.

If you add a calculated item to the PivotField.CalculatedItems collection of a PivotTable field, it’s also automatically added to the field’s PivotItemCollection collection.

See Also