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