In this section Hide
In the Breakdown Details dialog box, if you click Individual Values, the report includes a column or row for every value that you select. 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 individual values.
1. In the Breakdown Details dialog box, click Individual Values.
2. To include a column or row to represent null (missing) values for the variable, check Include a category for Null values.
3. To include a column or row in the report to represent all selected values for the variable (including null values if Include a category for Null values is checked), check Include a category for ALL selected values. . For reports that display percentages, the report must include a row or column for All.
Note: If a case is counted in multiple columns or rows, a count in the All column or row is not necessarily the same as the total of counts in other columns or rows of the report. Also, percentages in the columns or rows may add up to greater than 100 percent.
4. To include a column or row for values that are not represented by any other columns, check Include a category for all unselected values.
5. From the All Values list, select values for the variable.
Note: When a value is highlighted in the list, you can go to the next occurrence of a value starting with a character that you type. For example, you can highlight the first value in the list and type H to go to the first value starting with H.
6. Highlight one or more values in the list of all values. You can also do the following:
Button |
Use To |
Move highlighted values from the list of all values to the list of selected entries. |
|
Move all values from the list of all values to the list of selected values. |
|
Removes highlighted values from the list of selected values. |
|
Removes all values from the list of selected values. |
7. From the Breakdown values order field, select the breakdown values order.
8. When you are satisfied with the Selected Values list, click OK.
The Edit Report Columns page shows the selected values. Click Save to save your report definition so far.
9. To edit value labels for breakdown values, in the Breakdown Details section, click Edit Labels.
The Edit Labels dialog box appears. For more information, see Editing individual value labels.
10. Click OK.
The following example shows a report in which three different SOCs were selected:
In the following example, the All row shows the number of cases with any of the Gender values for each SOC. The All column shows the number of cases with any of the SOCs for each Gender. The Null column shows the number of cases (in this example, none) with no SOC for each Gender. All SOCs that are not any of the three selected SOCs are represented by the Other column:
Note: See Specifying content details for information about the behavior of the All row when unique counts are shown for column variables.