When you create an interactive report definition, you define a query that will be run when the report is run. The report is run against the cases found by the query. You can set up a breakdown variable to use user-specified query values as the breakdown details. For example, you can define a report that uses user-specified values for Outcome as breakdown values.
Note: You cannot define breakdown by query values for numeric or date variables.
1. In the Breakdown Details dialog box, click Query 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 the values provided to the query, including null values, 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, a count in the All column is not necessarily the same as the total of counts in other columns of the report.
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. Click OK.
Make sure that the query for the report definition includes the breakdown variable.