PivotField.Calculation Property
Returns or sets the type of calculation performed by the specified field. This property is valid only for data fields. Read/write XlPivotFieldCalculation.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property Calculation As XlPivotFieldCalculation
Get
Set
'Usage
Dim instance As PivotField
Dim value As XlPivotFieldCalculation
value = instance.Calculation
instance.Calculation = value
XlPivotFieldCalculation Calculation { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlPivotFieldCalculation
Remarks
For OLAP data sources, this property can only return or be set to xlNormal.