Export (0) Print
Expand All
Expand Minimize

XlPivotFieldCalculation Enumeration 

Specifies the type of calculation performed by a data PivotField when a custom calculation is used.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim xlPivotFieldCalculation1 As XlPivotFieldCalculation = XlPivotFieldCalculation.xlDifferenceFrom

public enum XlPivotFieldCalculation
public enum XlPivotFieldCalculation
public enum XlPivotFieldCalculation

Member nameDescription
xlDifferenceFromThe difference from the value of the Base item in the Base field.
xlIndexData calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))
xlNoAdditionalCalculationNo calculation.
xlPercentDifferenceFromPercentage difference from the value of the Base item in the Base field.
xlPercentOfPercentage of the value of the Base item in the Base field.
xlPercentOfColumnPercentage of the total for the column or series.
xlPercentOfRowPercentage of the total for the row or category.
xlPercentOfTotalPercentage of the grand total of all the data or data points in the report.
xlRunningTotalData for successive items in the Base field as a running total.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft