Aspose::Cells::Pivot::PivotShowValuesAsType enum

PivotShowValuesAsType enum

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

enum class PivotShowValuesAsType

Values

NameValueDescription
Normal0
Represents raw value, no custom calculation.
DifferenceFrom1
Shows the value as the difference from a specified base item.
PercentageOf2
Shows the value as a percentage of a specified base item.
PercentageDifferenceFrom3
Shows the value as percentage difference from a specified base item.
RunningTotalIn4
Shows the value as a running total along the specified base field.
PercentageOfRow5
Shows the value as percentage of the row total.
PercentageOfColumn6
Shows the value as percentage of the column total.
PercentageOfTotal7
Shows the value as percentage of the grand total.
Index8
Index calculation: (Cell Value × Grand Total of Grand Totals) / (Row Grand Total × Column Grand Total).
PercentageOfParentRowTotal9
Shows the value as percentage of its parent row item total.
PercentageOfParentColumnTotal10
Shows the value as percentage of its parent column item total.
PercentageOfParentTotal11
Shows the value as percentage of its parent item total in the specified base field.
PercentageOfRunningTotalIn12
Shows the value as percentage running total along the specified base field.
RankSmallestToLargest13
Ranks values from smallest to largest within the specified base field.
RankLargestToSmallest14
Ranks values from largest to smallest within the specified base field.

See Also