Sub Totals and Grand Totals help you visualise multiple levels of summary data at one go. Sub Totals is calculated as an aggregation of a specific set of metric data at an each individual grouping where as Grand Total is calculation on all the detailed data of that metric.
A Grand Total is a total of all calculations performed on a metric. A Sub Total is a total of a specific subset of metric data, totaled at the groups selected.
There are two ways this feature can be utilised:
The Summary table will allow users to apply totals on rows, and
The Matrix table will allow users to apply totals on both rows and columns.
