Showing grand totals for columns in cross tables

You can show a grand total for each category column in the cross table. A grand total displays the resulting value for the column 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 column.
Grand totals for columns
Note: The aggregated values for the grand totals are not calculated based on the visible, already aggregated column 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 Grand total average of a column takes into account all the data rows on which the column values are based, and not only the averages shown in the cross table column.

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 columns check box.

Result

Grand totals are displayed beneath each cross table column.