There are 11 options in total to create quick table calculations:
- Running Total progressively sums the aggregated marks within the partition and along a direction (across or down).
- Difference is the absolute difference between the mark and a reference mark: (Mark - Reference).
- Percent Difference states the relative difference: (Mark - Reference) / Reference.
- Percent of Total shows the contribution of the current mark to the total aggregation of marks within the scope.
Percent of Total calculations can also be turned on via Analysis | Percentage Of | ..., although this will affect all measures.
- Rank ranks the cells based on their value (with different options for how to differentiate between cells ...