How do I create a crosstab (a.k.a. cross table)?

This is one of the most common analysis tasks, and a full tutorial that integrates all of the tasks with an example data file is available here:

Here are the steps in general:
1. Press HOME > Page Layout > New Page > Title and Content to create a new page.
2. Press HOME > Tables > Table.
3. In the Select Data window that appears, select the data you want to see in the rows of the table..
4. In the HOME > Data Selection > By: text box, select the data you want to see in the columns of the table.
     Tip: if the data you want to see does not appear in the By list, it may be because it is free-form text data that respondents have typed.  You will need to convert this to categorical-type data first, by finding the table or chart of the data in your report, and clicking DATA MANIPULATION > Structure > Percentages.

An example crosstab is shown below.

It is often useful to show the number of observations in each cell of the table: HOME > Data Selection > Statistics - Cells > Count.

You can also view this table as a Grid of Bars chart: press HOME > Charts > Chart > Miscellaneous > Grid of bars plot.

Feedback and Knowledge Base