ShowAs Enumeration
Enumeration members
Enumeration members
DiffCol
DiffCol: = 3
Show differences between each item and the item in the previous column.
DiffColPct
DiffColPct: = 4
Show differences between each item and the item in the previous column as a percentage.
DiffRow
DiffRow: = 1
Show differences between each item and the item in the previous row.
DiffRowPct
DiffRowPct: = 2
Show differences between each item and the item in the previous row as a percentage.
NoCalculation
NoCalculation: = 0
Show plain aggregated values.
PctCol
PctCol: = 7
Show values as a percentage of the column totals for the field.
PctGrand
PctGrand: = 5
Show values as a percentage of the grand totals for the field.
PctPrevCol
PctPrevCol: = 11
Show values for each item as a percentage of the value in the previous column.
PctPrevRow
PctPrevRow: = 10
Show values for each item as a percentage of the value in the previous row.
PctRow
PctRow: = 6
Show values as a percentage of the row totals for the field.
RunTot
RunTot: = 8
Show values as running totals.
RunTotPct
RunTotPct: = 9
Show values as percentage running totals.
Specifies constants that define calculations to be applied to cells in the output view.