You can summarize the measure data in a report by adding column and row totals. Column totals provide a grand total of each measure column in a report, while row totals provide a grand total of each row in a report.
To add column totals to a report, open the More menu on the Designer toolbar, point to Column totals, and click Aggregate columns or Recalculate totals.
The Aggregate columns option provides a sum total for each column. As shown in the following image, the values in each measure column are summed into total values. Columns created by dimension fields in the Columns bucket are treated as separate columns for this purpose.
Alternatively, you can use a recomputed total to provide summed totals for measure fields from the data source but recalculate the total values for computed fields created in a report. To add a recomputed total to a report, open the More menu, point to Column totals, click Recalculate totals. Values for each measure field are recomputed after each value in the selected field.
For example, perhaps you have created a report that includes a calculated field, Revenue Per Item, that is evaluated after aggregation from Revenue divided by Quantity Sold. The following image shows a report containing that field, with summed totals added using the Aggregate columns option.
The total row contains summed values for the Revenue and Revenue Per Item fields.
By contrast, the following image shows the same report, but with recomputed totals, using the Recalculate totals option, instead.
In this report, the total values in the Revenue Per Item columns are recomputed for the entire report, since Revenue Per Item is a calculated field. On the other hand, the Revenue columns are still summed, since they come from the data source.
Note that the Recalculate totals option does not reapply prefix operators. Fields with prefix operators are summed just as they would be when applying a regular subtotal. In this case, COMPUTE fields, which are calculated fields evaluated after data aggregation, are recalculated.
You can also add row totals to a report to generate summed grand totals for each row of the report. To add row totals, open the More menu on the Designer toolbar and click Row totals.
Row totals behave differently depending on whether or not fields have been placed into the Columns bucket. If there are no fields in the Columns bucket, then all measure columns in the report are summed in a single Total column, as shown in the following image.
If there is a field in the Columns bucket, then instead of summing all columns, the row totals are evaluated for each measure field in the report, as shown in the following image.
Note that row totals provide sum values for the measures in each row, including instances when the report includes calculated fields.
If your report includes both column totals and row totals, then column totals are evaluated for any row total columns, as shown in the following image.
