The Categorical launch window has the following column roles:
X, Grouping Category
(Not applicable for the Structured tab.) Assigns a column as a grouping category. The responses are summarized for each group. If more than one grouping column is used, then the tabulation is nested by default. Use the Grouping Option in the launch window to change the summarization.
Sample Size
Assigns a column whose values define the number of individual units in the group to which that frequency is applicable. The sample size is used for multiple response roles with summarized data. See Example of Multiple Responses.
Freq
Assigns a column whose values define a frequency to each row for the analysis. The frequency role is used for summarized data.
ID
Assigns a column that identifies the respondent. This option is required when Multiple Response by ID is selected, and it is not used for any other response types.
By
Produces a separate report for each level of the By variable. If more than one By variable is assigned, a separate report is produced for each possible combination of the levels of the By variables.