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.
Results
The total shows the
sum of the cell values for the selected expression.