xlPivotFieldCalculation

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

xlDifferenceFrom2
xlIndex9
xlNoAdditionalCalculation-4143
xlPercentDifferenceFrom4
xlPercentOf3
xlPercentOfColumn7
xlPercentOfParent(Added in 2010)
xlPercentOfParentColumn(Added in 2010)
xlPercentOfParentRow(Added in 2010)
xlPercentOfRow6
xlPercentOfTotal8
xlPercentRunningTotal(Added in 2010)
xlRankAscending(Added in 2010)
xlRankDescending(Added in 2010)
xlRunningTotal5

xlDifferenceFrom
2
xlIndex
9
xlNoAdditionalCalculation
-4143
xlPercentDifferenceFrom
4
xlPercentOf
3
xlPercentOfColumn
7
xlPercentOfParent
(Added in 2010)
xlPercentOfParentColumn
(Added in 2010)
xlPercentOfParentRow
(Added in 2010)
xlPercentOfRow
6
xlPercentOfTotal
8
xlPercentRunningTotal
(Added in 2010)
xlRankAscending
(Added in 2010)
xlRankDescending
(Added in 2010)
xlRunningTotal
5

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top