You can display grand totals for columns as well as rows in a cross table. If the vertical axis is hierarchically structured, it is possible to display also column subtotals for different levels in the hierarchy.
Totals are calculated using the same aggregation or expression as is used for calculating the cell values. The calculation is not based on the aggregated values shown in the cross table cells; it is by default based on the underlying data table rows. For example, if 'Average' is used as aggregation method for the cell values, the grand total average of the column is not the average of the cell values; it is the average of all the underlying data rows. This is exemplified below, where a simple data table is visualized by a cross table:
The expression used for calculating the cell values is average (Avg). The Grand total is calculated on the underlying rows ((200+300+1+9+100)/5=122), and not on the cell values.