Displaying grand totals for columns or rows in a cross table
You can show a grand total for each column or each row in a cross table. A grand total is by default calculated using the same expression that is used for calculating the cell values. For example, a grand total can indicate a 'grand sum' or a 'grand average'.
About this task
In this example, grand totals for each column are shown.
![Grand totals for columns](../../images/cross_table_grand_total_columns.png)
In this example, grand totals for each row are shown.
Totals are not based on the aggregated values shown in the cross table cells; they are by default based on the underlying data table rows. 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 cell values are based, and not only the averages shown in the cross table cells. See Displaying totals.
Procedure
- Right-click the cross table, and select Properties in the opened menu.
- Click Totals.
- Under Display totals, select the Grand total for columns or the Grand total for rows check box.