How to Create a Crosstab

A crosstab is created when a second Variable Set is dragged onto a Summary Table.

Requirements

A data set containing the variables from which you want to create the crosstab. 

Method - from the Table menu

1. Click Table > Table from Dataset from the toolbar.
2. From the object inspector on the right, select the data you want to show in the rows of the table from the Data > Data Source > Rows dropdown box. 
3. Select the data you want to show in the columns of the table from the Data > Data Source > Columns dropdown box. 
   

Tip: It is often useful to show the count of observations in each cell of the table by selecting Data > Statistics - Cells > n from the object inspector.

Method - from the Data Sets tree

1. Select the variable you would like to place in the rows from the Data Sources tree and drag it onto a page.
2. Select the variable that you would like to place in the column from the Data Surces tree, drag it over to the table that was created in Step 1, and place it in the Columns field. Alternatively, you can drag it into the Data > Data Source > Columns field of the object inspector.
3. OPTIONAL: If you would like to quickly switch the rows and columns, click Switch rows and columns.

Tip: It is often useful to show the count of observations in each cell of the table by selecting Data > Statistics - Cells > n from the object inspector.

Manipulating crosstabs and controlling their appearance

The appearance of a table is governed by:

• The properties of the Variable Set:
  • Variable Set Structure
  • Value Attributes
  • Data Reduction
• The selections in the Data section of the Object Inspector on the right of the screen:
  • The data.
  • The statistics.
  • Filter(s) (see How to Apply a Filter).
  • Weight (see Weights in Displayr).
  • Appearance.

Next

How to Create Lots of Crosstabs

How to Create and Customize a Banner

Summary Tables and Crosstabs Video