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. |