Displaying grand totals and subtotals as sums of the cell values
By default, grand totals and subtotals in a cross table are calculated using the same aggregation or expression that is used for calculation of the cell values, and the calculations are based on the underlying data table rows. However, it is possible to base the totals calculations on the aggregated cell values. Then totals will be calculated as the sum of the cell values, no matter expression used for the cell values.
Procedure
Right-click the cross table, and select
Properties in the opened menu.
The
Properties popover is displayed.
Select
Totals.
The
Totals section is displayed.
Beneath
Display totals, select the totals to be visible in the cross table.
If any subtotals are displayed, select their position;
Before values or
After values.
Settings of calculations lists the expressions used for calculating the cell values on the Cell values axis. Click the expression, whose totals you want to calculate as a sum of the cell values.
Select
As sum of cell values beneath
Calculate totals.
Result
The total shows the sum of the cell values for the selected expression.