PivotCalculatedItemCollection Interface

Represents a collection of calculated items 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 PivotCalculatedItemCollection :
    ISimpleCollection<PivotItem>,
    IEnumerable<PivotItem>,
    IEnumerable,
    ICollection

VB.NET

Public Interface PivotCalculatedItemCollection
    Inherits ISimpleCollection(Of PivotItem),
             IEnumerable(Of PivotItem),
             IEnumerable,
             ICollection

Related API Members

The following members return PivotCalculatedItemCollection objects:

• PivotField.CalculatedItems

Remarks

Use the PivotField.CalculatedItems property to get access to the PivotCalculatedItemCollection collection. An individual calculated item is represented by the PivotItem object, which can be accessed by its index in the PivotCalculatedItemCollection collection.

To add a calculated item to the PivotTable field, use the PivotCalculatedItemCollection.Add method. To remove a calculated item from the PivotTable field, use the PivotCalculatedItemCollection.Remove or PivotCalculatedItemCollection.RemoveAt method.