officefileapi-devexpress-dot-spreadsheet-ef6b15ae.md
A collection of calculated fields in a PivotTable report.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public interface PivotCalculatedFieldCollection :
ISimpleCollection<PivotField>,
IEnumerable<PivotField>,
IEnumerable,
ICollection
Public Interface PivotCalculatedFieldCollection
Inherits ISimpleCollection(Of PivotField),
IEnumerable(Of PivotField),
IEnumerable,
ICollection
The following members return PivotCalculatedFieldCollection objects:
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.
See Also
PivotCalculatedFieldCollection Members