SPSS Viewer

The default tables produced may not display information as neatly as you would like, or the information may not clearly make your point.

With pivot tables, you can transpose rows and columns ("flip" the table), adjust the order of data in a table, and modify the table in many other ways. For example, you can change a short, wide table into a long, thin one by transposing rows and columns. Changing the layout of the table does not affect the results. Instead, it's a way to display your information in a more intuitive manner.

step Activate (double-click) the Owns PDA * Gender * Internet Crosstabulation table.

step If the Pivoting Trays window is not already visible, from the menus choose:

Pivot
 Pivoting Trays

Pivoting Trays provide a way to move data between columns, rows, and layers.

step Click one of the pivot icons to see what it represents. The shaded area in the table indicates what will be moved when you move the pivot icon. A pop-up label also indicates what the icon represents in the table.

step Drag the Statistics pivot icon from the Row dimension to the top of the Column dimension. The table is immediately reconfigured to reflect your changes.

The order of the pivot icons in a dimension reflects the order of the elements in the table.

step Drag the Owns PDA icon to the left of the Internet icon and release the mouse button to switch these two rows