Define breakdown by grouped values

If you click Grouped Values in the Breakdown Details window, the report will include a column or row for every group that you define. This option results in a static list of breakdown values that does not automatically adjust to changing source data.

Note: If there are more than 20,000 available values for the breakdown variable, you cannot use a breakdown by grouped values.

1.         In the left navigation pane, hover on the Data Analysis icon (Data Analysis icon), then click Report Definitions.

2.         On the Report Definitions page, accept the case series shown or click Browse to the right of Case Series to display the Select Case Series page and select a case series.

3.         Click a Report Definition's Row Action menu (Row Action menu icon), then click Edit.

4.         On the Edit Report Columns page, next to Breakdown Details, click Select.

5.         In the Breakdown Details window, click Grouped Values.

6.         Next to the Groups field, click New.

A message asks for the new group's name.

7.         Enter a name for the new group, and click OK.

8.         To include a column or row to represent null (missing) values for the variable, check Include a category for Null values.

9.         From the All Values list, select values to include in the group.

10.   Create other groups and select values to be included in them. Make sure that each group includes at least one value.

11.   From the Breakdown values order field, select the breakdown values order:

12.   To include a column or row for values that are not represented by any other columns, check Include a category for all unselected values.

13.   When you are satisfied with the groups and other options, click OK.

14.   The Edit Definition page shows the selected values. Click Save to save your report definition so far.

Note: You cannot save the report definition if all groups are empty (that is, have no values in them). If some groups are empty, the report definition is saved and the empty groups are ignored.