Change a List into a Crosstab

Change a list into a crosstab to view your data from a different perspective.

Procedure

  1. Click the columns to appear as columns or nested columns in the crosstab.
  2. From the Structure menu, click Pivot List to Crosstab.

Results

The list becomes a crosstab with the columns you selected in step 2 appearing as columns and nested columns. The unselected columns, except for measures, appear as rows and nested rows. If you have one measure, it becomes the cells of the crosstab. If you have more than one measure, they appear as columns.
Tip: To make all measures appear as rows, swap columns and rows.
Parent topic: Crosstabs