You can display grand totals for each row in the cross table. Grand totals are 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'.
In the cross table below, the aggregation method 'Sum' is used to aggregate the 'Sales' values, and accordingly, Grand totals are also calculated as a 'Sum'.
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 row takes into account all the underlying data table rows, and not only the averages shown in the cell values. See