In this article
The group answer function aggregates answers into new answers. It can be used when creating a net. For example, if you have regions A, B, C, D and need a net of A+B. Or another use case is creating different age groups.
It’s important to remember that once you have a group answer, it does NOT affect the base size in the calculations.
Grouped Answers are created and edited from the Answer block view. To create a grouped answer, select the answers to be merged to a new Grouped answer and then apply the option “Create Grouped answer” in the context menu.
To edit, or delete, an existing grouped answer, go to Create grouped answer:
And use the edit/delete icons displayed in the most right column of the screen, see example of these in the image below.
Note: Grouped answers are saved on ID 100001, or the highest available ID.
The Grouped answer functionality has been improved when using the Grouped answer to create Totals. A option makes it now possible to include both all existing and future added answers automatically in a Grouped answer which results in less manual work in projects where new answer alternatives are added continuously.
Note: grouped answers cannot be created based on answers within computed variables.
The content of a Grouped answer can be previewed directly in the Answer grid from the answer block page.
Here we see a preview of a Grouped answers in the Answer block grid. To edit the Grouped answer click any answer and the Grouped answer edit view is shown.
Creating Nets/Grouped Answers in the Cross Table Tool
Grouped nets/answers can also be created in the Cross Table Tool. This functionality is available for all users, not only administrators.
For highest reporting flexibility, a grouped answer created in the Cross Table Tool is present only in the sheet the user works in. Therefore, reports or tables in other workbooks/sheets are not affected.
To create a net/grouped answer in the Cross Table tool:
Enter the answer alternative selection panel.
Click Add net/Grouped Answer.
Enter the label of the net/grouped answer. This must be unique and cannot clash with any other label in the same answer list.
Select the answer options to be included.
Click Save
Here we see the creation of a Top 2 box in a scale answer block
Note: If two ore more questions share the same answer block, the created group answer appears in all questions sharing this answer block
Note: The created grouped answer is connected to the current sheet. If a new sheet is created, the grouped answer needs to be recreated. This doesn't apply if the sheet is merely copied.
Note: Grouped answers can be created on all categorical questions, including index questions. The only exception is computed variables in the Cross Table Tool.
Editing and Deleting Nets/Grouped Answers in the Cross Table Tool
To edit or delete a grouped answer you created, use the options in the highlighted image below.