Hiding Subtotaled Categories

You can suppress the display of the categories that define a subtotal and display only the subtotal, effectively "collapsing" categories without affecting the underlying data.

  1. Open the table builder (Analyze menu, Tables, Custom Tables).
  2. Click Reset to clear any previous settings in the table builder.
  3. In the table builder, drag and drop Age category from the variable list to the Rows area on the canvas pane.
  4. Right-click Age category on the canvas pane and choose Categories and Totals from the pop-up menu.
  5. Select 3.00 in the Value(s) list.
  6. Click Add Subtotal to display the Define Subtotal dialog box.
  7. In the Label text field, type Less than 45.
  8. Select (check) Hide subtotaled categories from the table.
  9. Then click Continue.

    This inserts a row containing the subtotal for the first three age categories.

  10. Select 6.00 in the Value(s) list.
  11. Click Add Subtotal to display the Define Subtotal dialog box.
  12. In the Label text field, type 45 or older.
  13. Select (check) Hide subtotaled categories.
  14. Then click Continue.
  15. To include a total with the subtotals, select (check) Total in the Show group.
  16. Click Apply.

    The canvas reflects the fact that subtotals will be displayed but the categories that define the subtotals will be excluded.

  17. Click OK to produce the table.
Figure 1. Table displaying only subtotals and totals
Table displaying only subtotals and totals