Skip to Main Content

Simmons Catalyst Database Guide Version 2.0: Creating a Crosstab

Step-by-Step: How to Create a Crosstab



What is a Crosstab?

A crosstab is a table which shows a relationship between the variables in the columns and the rows.  In this example we will be creating a crosstab to look at the relationship between drinking Monster energy drinks and the age of the respondent.  Provided below are the steps to build your crosstab.


Select Crosstab

Go to the Catalyst menu at the top of the page and click on the heading called ANALYZE.  Select CROSSTAB from the drop-down menu.







Select Composer

In the top left corner of the screen, click on the COMPOSER button which will take you to the screen where you start building your crosstab. Underneath the COMPOSER button is a drop-down menu where you can select which Simmons study you want to use when creating your crosstab.  















Enter Your Search Terms

You can search for products, brands, consumer attitudes and media in Simmons.  Type your search terms in the textbox.   In the first section of the Composer page you will see a list of relevant categories that match your search terms. 


Choose Your Survey Question

Select one of the categories in the first section on the left . Click on the  subcategories beneath it until you reach the survey questions.  When you click on a survey question, a list of responses will populate the second section. Choose the responses you want to include in your crosstab and click the ADD button after each selection is made.  


Add Survey Responses to Your Columns

Survey data such as products, brands, lifestyle statements, media and anything that you purchase should be added to the fourth section of the Composer page. Once you have chosen your survey responses and moved them to the third section, select the COLUMNS button at the bottom of the screen to move the survey responses to the COLUMNS box in the fourth section.


Add Survey Responses to Your Rows

Once you have finished working on the columns, you can start adding responses to demographic questions.  These would be placed in the rows.  Demographics include information such as age, gender, income, race, education, and marital status. 

Type the term DEMOGRAPHICS in your search box and hit enter.  The category of DEMOGRAPHICS will now be in the first section of the Composer page.  Double click on it. At this point, different types of individuals who answered this survey including head of household, homemaker/personal shopper, spouse, etc. will appear of the screen. Choose one of these types of survey respondents for your crosstab by double clicking on it.


Choose a type of survey respondent from the list of options and double clicked on it. Different types of demographic information will populate the first column of the Composer page.  Scroll down and select which one to include in the crosstab. 

Survey responses will now appear in the second column. Click on the check box for the responses that will be added to the crosstab.  Select the option called EACH toward the bottom of the page so that all of the responses are added individually to the crosstab.  Next, click the ADD button which will add the survey responses to the third section of the Composer page.


Now that  you have your survey responses in the third section of the Composer page, click on ROWS at the bottom of the page to move the survey responses to the rows box located in the fourth section.


Run Your Report

After you have finished adding survey responses to the columns and the rows, you are ready to run your report. Click on the "Run Report" button to generate the crosstab report.


Crosstab Report 

Notice when you look at the crosstab report that the demographic of age can be found in the rows on the left side of  the page.    The answer to the survey question that asked if you have drank Monster energy drinks in the last 6 months is at the top of the page on the right-hand side.  The report can be viewed in the PRIVATE EYE VIEW or the CROSSTAB VIEW and if you want to revise your crosstab simply click on the COMPOSER button. The example shown in the image provided below is in the  PRIVATE EYE VIEW.

The crosstab report contains different types of information that help you to analyze the data.  To learn more about how to analyze this crosstab report click on the tab on this libguide that says "how to analyze a crosstab" 


Export Your Results

From the PRIVATE EYE VIEW screen or the CROSSTAB VIEW screen, there are three dots in the top right corner next to the AutoSave button.  To export the crosstab report click on the three dots.  This will open a menu where one can choose to export, open or import a crosstab.   Click on EXPORT  which will open another menu which gives the option of exporting the crosstab in a SPC, EXCEL, or CSV format.