How to Create Lots of Crosstabs

This article describes how to create multiple crosstab outputs at once or in batch form.

Requirements

A Displayr document and data set.

Method

1. Go to any of the following menu options::
   • In the Report tree, select  + > Report > Crosstabs
   • Table > Report > Crosstabs from the toolbar.
2. Click Yes or No depending on whether you would like the outputs to be placed on separate pages in your document.
3. Select the variable(s) you would like to appear in the rows. You can select multiple variables by holding down the "Ctrl" or "Shift" key.
4. Click OK.
5. Select the variable(s) you would like to appear in the columns. You can select multiple variables by holding down the "Ctrl" or "Shift" key.
6. Click OK.
7. Any Nominal - Multi, Binary - Grid, and Numeric - Grid variable sets will be copied and flattened before using them in a crosstab. The flattened copy will contain all of the cells from the original question in a single column or row.

8. A new folder will appear in the Report tree with the crosstab outputs:

   

Adding Additional Statistics to the Crosstabs

By default, your crosstabs will display column %s. You can add other statistics to each table one at a time, or, if you prefer, modify the statistics for all tables at once. To change the statistics on all of the tables:

1. Select the crosstabs tables you want to change by holding the "Ctrl" or "Shift" key.
2. In the object inspector , select Data > Statistics > Cells/Below/Right and choose the statistics you want to include in the tables.

Sorting Crosstabs Tables by Significance

To sort crosstabs by significance:

1. Select two or more pages or a folder in the Report tree.
2. Right-click and select Sort > Pages > By Significance

Delete Crosstabs Tables for Different Significance Levels

If you created many crosstabs and only want to keep the ones that are significant above a particular level, for example, >= 0.05, you can do the following:

1. Select the pages or folders that you want to modify.
2. Right-Click > Delete and choose the option you want from the menu.
   

Next

Creating Summary Tables and Crosstabs

Summary Tables and Crosstabs Video

How to Create Lots of Banner Tables