PivotCalculatedFieldCollection Interface

A collection of calculated fields in a PivotTable report.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public interface PivotCalculatedFieldCollection :
    ISimpleCollection<PivotField>,
    IEnumerable<PivotField>,
    IEnumerable,
    ICollection

VB.NET

Public Interface PivotCalculatedFieldCollection
    Inherits ISimpleCollection(Of PivotField),
             IEnumerable(Of PivotField),
             IEnumerable,
             ICollection

Related API Members

The following members return PivotCalculatedFieldCollection objects:

• PivotTable.CalculatedFields

Remarks

Use the PivotTable.CalculatedFields property to get access to the PivotCalculatedFieldCollection collection. An individual calculated field is represented by the PivotField object, which can be accessed by its name or index in the collection using the PivotCalculatedFieldCollection.Item property.

To add a calculated field to the pivot table, use the PivotCalculatedFieldCollection.Add method. To remove a calculated field from the PivotTable report, use the PivotCalculatedFieldCollection.Remove or PivotCalculatedFieldCollection.RemoveAt method.