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

PivotItem Interface

Represents an item in a PivotTable field.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

public interface PivotItem

#Remarks

Each item represents a unique entry from a field in the source data. All field items are stored in the PivotItemCollection collection returned by the PivotField.Items property. An individual PivotItem object can be accessed in the collection using indexer notation.

In addition to the items from the source data, a pivot field can also contain one or more calculated items, whose values are produced based on custom formulas. To add a calculated item to the PivotTable field, use the PivotCalculatedItemCollection.Add method of the PivotField.CalculatedItems collection.

See Also