| title | api_name | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|
XlPivotFieldCalculation enumeration (Excel) |
|
94ceaa53-9dfc-149a-6aed-30d8fdb57b5b |
06/08/2017 |
medium |
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. |
[!includeSupport and feedback]