Define breakdown by distinct values

In the Breakdown Details dialog box, if you click Every Distinct Value, the report includes a column or row for every distinct (unique) value of the variable. This option uses the values available at the time the report is run, not at the time you define the report.

1. In the left navigation pane, hover on the 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 (), then click Edit.
4. On the Edit Report Columns page, next to Breakdown Details, click Select.
5. In the Breakdown Details dialog box, click Every Distinct Value.
6. To include a column or row in the report to represent all 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.
7. To include a column or row to represent null (missing) values for the variable, check Include a category for Null values.
8. Click OK.

Example

In the following example, the All row shows the number of cases with any of the Gender values for each Age Group. The All column shows the number of cases with any Age Group for each Gender. Also, the NULL column shows the number of cases (in this example, none) that have no Age Group for each Gender.

Note:

See Specifying Content Details for information about the behavior of the All row when unique counts are shown for column variables.