Designing Crosstabs

Create a Basic Crosstab

1. On the Crosstabs list page, click New
2. Specify a name for the new crosstab (A)
3. On the Design tab, drag variables from the left box to the appropriate section (Columns, Rows, etc.) in the right box (B) - use the diagonal double-headed arrow next to the Columns tab to Transpose variables back and forth
4. If auto-preview is turned on, the right pane will update (C)
5. Click Save or Save As (D)
6. Click Close Editor to maximize viewing space (E)

Create a Crosstab with Nested Tables

1. On the Crosstabs page, click New
2. Specify a name for the new crosstab
3. On the Design tab, drag one variable from the left to the Columns or Rows area on the right
4. Drag a second variable from the left onto the name of the first variable in the right box
5. Repeat as necessary
6. Click Save
7. Click Close Editor to maximize viewing space

Create a Crosstab with Grid Variables

1. If necessary, first create a multiple response variable that is set to "Count All Values."
2. In the left-most pane of the crosstab editor, open the Grid Variables category at the bottom of the list
3. The multiple response variable will appear here - drag it to either the columns or the rows
4. MarketSight will generate the full grid

Create a Crosstab with Automatic Date Ranges

1. On the Crosstabs page, click New
2. Specify a name for the new crosstab
3. On the Design tab, drag one date variable from the left to the Columns box on the right (Note: this variable MUST be in date format)
4. Click on the "Create Value Ranges" link that appears to the right of the variable in the Columns box
5. Choose your date range settings from the menus

Set Custom Date Formatting for Automatic Date Ranges

1. After opening the "Create Value Ranges" dialog, enter a combination of the following into the case-sensitive "Custom Format Template" box in the lower right corner

Symbol	Resulting Date Format
d	Displays the day as a number without a leading zero.Examples: 1, 31
dd	Displays the day as a number with a leading zero.Examples: 01, 31
ddd	Displays the day as an abbreviation.Examples: Sun, Sat
dddd	Displays the day as a full name.Examples: Sunday, Saturday
w	Displays the day of the week as a number.Examples: 1 (Sunday) through 7 (Saturday)
ww	Displays the week of the year as a number.Examples: 1, 54
m	Displays the month as a number without a leading zero.Examples: 1, 12
mm	Displays the month as a number with a leading zero.Examples: 01, 12
mmm	Displays the month as an abbreviation.Examples: Jan, Dec
mmmm	Displays the month as a full month name.Examples: January, December
q	Displays the quarter of the year as a number.Examples: 1, 4
y	Displays the day of the year as a number.Examples: 1, 366
yy	Displays the year as a two digit number.Examples: 00, 99
yyyy	Displays the year as a four digit number.Examples: 1000, 9999

Create a Grid Question Crosstab

Grid questions in MarketSight are created by using select multiple response variables in the columns or rows of your crosstab. If multiple response variables are not already present within your dataset, you will want to go to the Variables page to create one. In order to use multiple MRVs within the same table, each MRV must share the same column values.

1. Open the "Grid Variables" category in the left list (A)
2. Drag the desired variable into your columns or rows (B)

Transpose Variables in a Crosstab

1. Click on the Transpose option (A or B)

Sort a Crosstab

1. When viewing your crosstab, click on Sort Options in the right preview window, next to the column headers
2. Select desired sort settings
3. Click OK

Suppress Empty Columns or Rows

If your crosstab contains column(s) or row(s) that do not contain respondents (all values are shown as 0) or data (all values are shown as dashes), you can hide those from view.

1. Click on the "Hide Empty Columns" or "Hide Empty Rows" checkboxes on their respective tabs

Crosstab Editor Shortcuts

• If all variable values are deselected, use Alt+Click to select everything BUT the value alt-clicked on
• If all variable values are selected, use Ctrl+Click to deselect everything BUT the value ctrl+clicked on

Crosstab Layout Options

MarketSight offers several layout options based on the calculations and row variables you've added to your crosstab.

Display calculations in rows

Display calculations in columns

Display calculations in mixed

This mode displays value-level calculations in columns and variable-level calculations in rows.

Display values in rows

This is the MarketSight default.

Display values in columns

Displays values in columns. This mode is only available if all row variables in a crosstab share the same set of responses. Note: No statistics are run when values are displayed in columns.

Change Layout Options

1. When looking at your crosstab, click the Layout Options button
2. Select the desired setting
3. Click outside the box to close