XlPivotFieldCalculation enumeration (Excel)
Specifies the type of calculation performed by a data PivotField when a custom calculation is used.
| 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. |
| xlPercentOfParent | 12 | Percentage of the total of the specified parent Base field. |
| xlPercentOfParentColumn | 11 | Percentage of the total of the parent column. |
| xlPercentOfParentRow | 10 | Percentage of the total of the parent row. |
| 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. |
| xlPercentRunningTotal | 13 | Percentage of the running total of the specified Base field. |
| xlRankAscending | 14 | Rank smallest to largest. |
| xlRankDecending | 15 | Rank largest to smallest. |
| xlRunningTotal | 5 | Data for successive items in the Base field as a running total. |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.