Multitables allow you to create analyses using multiple column variables. Sometimes called ‘banners’ or ‘crossbreaks’, they let you quickly see multiple breakdowns of a variable of interest. To use multitables, start by selecting multitable view from the view toggle at the top of the application:
Using Existing Multitable Definitions
When multitable view is opened, the most recently created multitable definition that is available to you will be applied, with the first variable in the dataset being used as the rows.
To change the multitable definition, click the name in the upper left and select the definition you want to use from the dropdown menu.
Viewing means, discrete values, or ranges
If you are using a numeric variable or a categorical variable that has numeric values (see Variable Properties), you can open the dropdown next to the row variable to view means (a single row showing mean values), discrete values (a separate row for each values), or ranges (values automatically binned into ranges).
Exporting a Multitable to Excel
You can export the currently displayed multitable to Excel by clicking Export in the upper-right corner in multitable view, and then choosing Export this table. See Exporting Tab Books for more information about exporting an entire tab book using the currently selected multitable header.
Creating and Editing Multitable Definitions
You can create one or more multitable definitions (collections of column variables) in a dataset. If you are a dataset editor, you can make these definitions available to all users on a dataset.
When multitable view is opened, if there are no multitable definitions available to you, the builder will open immediately. Otherwise, you can open the builder by clicking the multitable name in the upper-left corner and selecting New multitable…. You can also view or edit an existing multitable by hovering over it in the dropdown list and clicking view or edit. Which option is available depends on whether you have permission to edit that multitable - multitables that you do not have permission to edit will have a dot next to them, just like filters.
You can add variables to the multitable definition by clicking them or dragging them from the sidebar. You can remove a variable that you’ve added by hovering over it and clicking the x that appears next to the name.
You may wish to hide some columns of a multitable (for example ‘decline to state’ or ‘not asked’). You can hide a multitable column while in the multitable builder by clicking on the column title – it will turn gray. Click the column title again to unhide it. When the multitable definition is used, this column will not be displayed. At this time, when exporting to a tab book (see above), all columns will be exported, whether hidden or not – we will be improving this in a future release.
Sharing a Multitable
If you are a dataset editor or if you are a member of a team that has access to this dataset, you will see the Shared with toggle in the upper-right corner.
Only dataset editors will see the All dataset viewers option. If you are a member of any teams that can access this dataset, they will appear in this list (e.g. Design Team in the example above).
Deleting a Multitable
To delete a multitable definition, edit it, click Delete in the lower-right corner, and confirm that you’d like to delete it.