Add nested columns to a crosstab report

Apply subgroups to a crosstab report and find correlations between two fields as columns.

Prerequisites:

Create a crosstab report

  1. Open the Analytics app and on the analytics menu, click Crosstabs.
  2. On the Crosstabs page, click the name of a crosstab report.
  3. On the left of the page, under the Columns section, click Edit.
    Tip: If you close the Edit pane, click Expand to open it again.
  4. In the Fields section of the Customize Columns dialog, select a field to be compared as a column.

    The following fields are available based on what was selected when creating a dataset.

    Fields Description
    Survey Name Contains all questions from a survey.
    Custom Fields Contains custom fields such as Source which is a collection of multiple surveys used to compare data from one survey to another.
    Profile Variables Contains profile variables.
    Note: A limit of 40 columns can be added. Each field has a number of columns and in total they can not surpass 40.
  5. Click the right arrow to add the field to the Editor.
  6. To nest a column, click the Add button.
  7. Select a question from the list and click the right arrow to move it.
  8. Optional: Add additional columns to the report.
    Note: There is a limit of 3 levels for nested columns. Nested columns do not go beyond grandchild columns.
    Type of column Description Before Result
    Parent column
    1. In the Fields section, select a question.
    2. Click the right arrow to move it to the Editor.
    Child column
    1. To nest child columns, click the Add button at the parent level column.
    2. Select a question from the list and click the right arrow to move it to the Editor.
    Grandchild column
    1. To nest grandchild columns, click the Add button at the child level column.
    2. Select a question from the list and click the right arrow to move it to the Editor.
    Note: There are two possible cases that can occur from deleting or updating a custom field:
    1. A custom field is removed but it still appears in the crosstab report. In this case, click Remove in the Customize Columns dialog, to manually delete the custom field.
    2. Changes to a custom field cause a column to be removed from a crosstab report. In this case, manually add in the removed column.
  9. Click Preview to see how the columns will look before it is saved.
  10. Click Save.