XlPivotFieldCalculation Enumeration

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

Version Information
 Version Added:  Excel 2007

Name Value Description
xlDifferenceFrom 2 The difference from the value of the Base item in the Base field.
xlIndex 9 Data calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)).
xlNoAdditionalCalculation -4143 No calculation.
xlPercentDifferenceFrom 4 Percentage difference from the value of the Base item in the Base field.
xlPercentOf 3 Percentage of the value of the Base item in the Base field.
xlPercentOfColumn 7 Percentage of the total for the column or series.
xlPercentOfRow 6 Percentage of the total for the row or category.
xlPercentOfTotal 8 Percentage of the grand total of all the data or data points in the report.
xlRunningTotal 5 Data for successive items in the Base field as a running total.