Rollup Totals
We are introducing a new type of total that aligns with the metric it aggregates. For example, if the metric is SUM, the rollup will also use SUM, and so on.
Rollup totals are “smart” aggregations. They are particularly useful for tables displaying metrics that represent average values, helping to avoid aggregations like averages of averages.
For example:
• For the Won metric, the rollup represents the sum of all regions' won amounts, making the Sum and Rollup (Total) equal.
• For the Avg. Won metric, instead of averaging the row’s values (which are already averages), the rollup averages the original underlying data before it was aggregated by the Won metric and divided into regions like East Coast and West Coast. Consequently, the value of Avg (an average of averages) differs from the Rollup (Total) average (an average based on the original data).
Learn More:
Rollup Totals