.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

PivotItem Interface

Represents an item in a PivotTable field.

Namespace: DevExpress.Spreadsheet

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


public interface PivotItem


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.

The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotItem interface.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also