PivotItem Interface

Represents an item in a PivotTable field.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

public interface PivotItem

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 is 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. Their 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

PivotItem Members

Pivot Tables in Spreadsheet Documents

Pivot Table Structure

WinForms Spreadsheet Control Examples

DevExpress.Spreadsheet Namespace