Showing grand totals for rows in cross tables

You can show a rand total for each category row in the cross table. A grand total displays the resulting value for the row after applying the aggregation method that is selected on the cell values axis. For example, a grand total can indicate a 'grand sum' or a 'grand average'.

In the cross table below, the aggregation method 'Sum' is used to aggregate the 'Sales' values, and accordingly, Grand total shows the result of summing the values in each cross table row.
Grand total rows
Note: The aggregated values for the grand totals are not calculated based on the visible, already aggregated row values. Instead, the grand total calculation goes back to the underlying data table, and its data row values. For example, if 'Average' is used as aggregation method, the displayed Grand total is the calculated average of all the underlying data table rows, on which the cross table row values are based, and not only the averages shown in the cross table row.

Procedure

  1. Right-click the cross table, and select Properties in the opened menu.
    The Properties popover is shown.
  2. Click Grand total.
    The Grand total section is shown.
  3. Select the Grand total for rows check box.

Result

Grand totals are displayed to the right of each cross table row.