Totals and Category Control

You can create tables with categories in the opposite dimension from the variables only if all of the variables in the table have the same categories, displayed in the same order. This includes totals, subtotals, and any other category adjustments you make. This means that any modifications you make in the Categories and Totals dialog box must be made for all variables in the table that share the categories.

1. Open the table builder again (Analyze menu, Tables, Custom Tables).
2. Right-click the first confidence variable in the table preview on the canvas pane and choose Categories and Totals from the pop-up menu.
3. Select (check) Total in the Categories and Totals dialog box and then click Apply.

   The first thing you'll probably notice is that the category labels have moved from the columns back to the rows. You may also notice that the Category Position control is now disabled. This is because the variables no longer share the exact same set of "categories." One of the variables now has a total category.

4. Right-click any one of the confidence variables on the canvas pane and select Select All Row Variables from the pop-up menu--or Ctrl-click each stacked variable on the canvas pane until they are all selected (you may have to scroll down the pane or expand the table builder window).
5. Click Categories and Totals in the Define group.
6. If Total isn't already selected (checked) in the Categories and Totals dialog box, select it now and then click Apply.
7. The Category Position drop-down list should be enabled again, since now all of the variables have the additional total category, so select Row Labels in Columns.
8. Click OK to create the table.