Skip to Main Content
Michigan State University

Simmons Catalyst User Guide

Formerly known as Simmons Insights, Simmons OneView and Simmons Choices3.

Step-by-Step: How to Create a Cross Tab Report

1. Opening the report tool

To start making your own crosstab report, click on "New Report" in the upper right hand corner of the screen and then select Crosstab from the options in the dropdown menu. A screenshot of the Simmons Catalyst landing page, with a circle around the New Report button and an arrow pointing to the Crosstab option in the drop down menu.

2. Enter Search Terms

Simmons has a "smart search" feature. Start by typing in keywords to search for a variable.

A screenshot of the crosstab report creator in Simmons Catalyst. The example is searching for jeans.

3. Create rows or columns

Add variables to either columns or rows by dragging your selected variables to either the rows or columns section of the report generator. Your choice of whether you use columns or rows is up to you, you are creating your own table. Continue adding variables using these steps.

A screenshot of the Simmons Catalyst crosstab report creator with a search for jeans done and a selection of brands of jeans selected and moved to the columns section of the report creator.

4. Add demographic data

In order to create a cross tab, you have to create rows to compare with the data in your columns. Search for variables, then add to Rows by dragging variables to the rows section just like we did in step 2. It makes it easier if you only have demographic data in either rows or columns, not both. So in this example we've put brands of jeans in our columns so we will put demographic data in the rows. Use the search to narrow your variables, especially when searching for demographic data such as age.

A screenshot of Simmons Catalyst's Crosstab report creator. The age variables are highlighted and moved to the rows section of the creator.

4. Run the Cross Tab

Click "run report" in the bottom right corner of the report builder.

5. View your Cross Tab

The default view of the report is the "Private Eye" feature. Use the "View" menu on the left to display the "Cross Tab View" (the grid icon).

Screenshot of a crosstab report in Simmons Catalyst. The view menu at the left is circled to highlight where to click to change the look of the report.

6. Export Your Work

The cross tabs you have created can be exported to either an .XLS or .CSV file for you to view and manipulate in Microsoft Excel or other spreadsheet applications.

You can also save your Cross Tab as a .SPC file. If you return to Simmons Catalyst at a later time, you can upload the .SPC file to continue where you left off.

To export, select the three horizontal dots to the right of the AutoSave indicator. This will open the Share menu. Then click on Export, and select your desired format.

Screenshot of Simmons Catalyst crosstab report with circles around the share menu and export features.