Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotItemCollection Interface

Represents a collection of PivotItem objects in a PivotTable field.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.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