How a column shows its numbers – without changing the data („Show values as“):
Mode
Shows
Flat table
Tree / row groups
Pivot
"percentOfColumnTotal"
value / sum of the column
✓
sum of the (filtered) leaf rows
cell / column total
"percentOfGrandTotal"
value / grand total
= column total
= column total
cell / grand total
"percentOfParentTotal"
value / total of the parent
= column total
value / sum of its siblings (each group = 100 %)
cell / parent row
"percentOfRowTotal"
value / row total
–
–
cell / row total
"differenceFromPrevious"
value − value of the row above
✓ (first row empty)
among siblings
–
"runningTotal"
sum up to this row (display order)
✓
among siblings
–
"rank"
1 = largest value, ties share a rank (1, 2, 2, 4)
✓
among siblings
–
The reference are the filtered rows (like the total row). Not applicable (–): the raw value is shown.
Values that are no numbers and a total of 0 give an empty cell.
How a column shows its numbers – without changing the data („Show values as“):
"percentOfColumnTotal""percentOfGrandTotal""percentOfParentTotal""percentOfRowTotal""differenceFromPrevious""runningTotal""rank"The reference are the filtered rows (like the total row). Not applicable (–): the raw value is shown. Values that are no numbers and a total of 0 give an empty cell.