PivotShowValuesAsType

PivotShowValuesAsType enumeration

Represents the calculation type for the “Show Values As” feature of pivot field values.

Values

NameValueDescription
Normal0Represents raw value, no custom calculation.
DifferenceFrom1Shows the value as the difference from a specified base item.
PercentageOf2Shows the value as a percentage of a specified base item.
PercentageDifferenceFrom3Shows the value as percentage difference from a specified base item.
RunningTotalIn4Shows the value as a running total along the specified base field.
PercentageOfRow5Shows the value as percentage of the row total.
PercentageOfColumn6Shows the value as percentage of the column total.
PercentageOfTotal7Shows the value as percentage of the grand total.
Index8Index calculation: (Cell Value × Grand Total of Grand Totals) / (Row Grand Total × Column Grand Total).
PercentageOfParentRowTotal9Shows the value as percentage of its parent row item total.
PercentageOfParentColumnTotal10Shows the value as percentage of its parent column item total.
PercentageOfParentTotal11Shows the value as percentage of its parent item total in the specified base field.
PercentageOfRunningTotalIn12Shows the value as percentage running total along the specified base field.
RankSmallestToLargest13Ranks values from smallest to largest within the specified base field.
RankLargestToSmallest14Ranks values from largest to smallest within the specified base field.