Showing subtotals in cross table columns

If the vertical axis in a cross table is structured hierarchically, it is possible to show subtotals within the cross table columns.

In the hierarchy below, subtotals for the month columns are displayed on the 'Country' level.
Subtotals in a cross table
If the hierarchy on the vertical axis has more than two levels, you can specify on which levels subtotals should be displayed.

Procedure

  1. Right-click the cross table, and select Properties in the opened menu.
    The Properties popover is shown.
  2. Click Subtotals.
    The Subtotals section is shown.
    Subtotals section in Properties
  3. Beneath Show subtotals for, select the levels in the hierarchy for which subtotals should be displayed. (In the hierarchy above, there is only one possible level.)
  4. Specify where in the cross table column the subtotals should be displayed, Before values or After values .