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.

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

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.

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.

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.

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