PivotItem Interface

Represents an item in a PivotTable field.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

public interface PivotItem

VB.NET

Public Interface PivotItem

Related API Members

The following members return PivotItem objects:

• PivotCalculatedItemCollection.Add(String, String)
• PivotCalculatedItemCollection.Add(String)
• PivotCalculatedItemCollection.First
• PivotCalculatedItemCollection.Last
• PivotDataField.BaseItem

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.