Crunch allows users to combine categories into a new variable, or as a subtotal of categories. For example, if you asked people to rate their preference on a scale of 1 to 10, you might want to see how the people who provide a rating between 1 and 5 compare to those who rated it between 6 and 10. This goes by a number of names, including “Top Box” or “Nets”, depending on the use case. In Crunch, we call this family of features Subtotals.
Subtotals can be applied to any Categorical variable by opening the variable Properties menu and selecting Subtotals. This brings up a list of the variable categories, which allows you to insert subtotals above or below the categories. In rare cases, it may make sense to insert a subtotal in the table body, but in general, subtotals are best grouped above or below the categories.
To create either subtotals, click the plus sign where you want the subtotal to appear in the list of categorical variables:
Then, drag the categories whose values you want to aggregate in the subtotal:
When you go back to the variable card, you will now see the subtotals next to the existing categories:
Whenever you include this variable in an analysis or multitable, the subtotals will be cross-tabulated just like any other category. For example, here we are taking a look at our subtotaled categories by gender:
Multiple Response Variables
Categories of a multiple response variable can also be combined, though it’s not as simple as adding up their counts as it is for a regular categorical subtotal. As for categorical variables, you access subtotals from the variable properties menu and clicking the Subtotals button.
Add a new subtotal by clicking the “Create subtotal” button, and then give your new subtotal a name. Drag in the categories you want to include in this subtotal, and then click Done. Categories you no longer want to include can be removed by clicking the small "x" icon which appears upon hover over each category in the drop-zone.
Unlike with categorical variable subtotals, the subtotals created for multiple response variables are regular categories just like the others, and when you save your changes you are creating a new, additional, variable in the dataset. You will therefore always be prompted to give this new variable a name and an alias, though you can typically just accept Crunch’s suggestions for each of these.
Previously created multiple response variables with subtotals can be edited by returning to the properties panel for that variable and re-entering the “Subtotals” interface, from where you can add new subtotals, delete existing subtotals, or make edits to the categories included in subtotals.