Crosstabs

Crosstabs summarize data across multiple sets of related fields and are a more compact representation than a table.

• Columns and Rows specify properties
• Cells contain the summarized measurements.

Format Options

• Fields can be added as
  • Row groups
  • Column groups
  • Measures.
• To add a field:
  • Drag it into the crosstab
  • Click it in the list of fields and select an option from the context menu.

    You can add fields more than once (ex. you can add a field as both a measure and row group).

• Row and column groups are arranged in hierarchies. To rearrange the hierarchy:
  • Drag the group headings.
  • Click a heading and select a Move option from the context menu.
  • Use the cursor keys.

    Rearranging the groups may change the preview data in the editor.

• When the crosstab includes more than one row group or more than one column group
  • Click the arrow in each heading cell to collapse the inner group.
  • Click the arrow again to expand the inner group once more.

    When you collapse a group, its summary is automatically displayed; this prevents invalid crosstab layouts in which there is nothing to display for some totals if the the summary has been deleted previously.

• To pivot the crosstab, click . The row and column groups will switch places.
• Measures are arranged in cells. You can add any number of measures. All the measures appear together in every cell. To rearrange the measures, you can:
  • Drag them in the top-most row of cells.
  • Click a measure in the top-most row and select a Move option from the context menu.
  • Press the up and down arrow keys on your keyboard.
• All row and column groups are summarized automatically:
  • To turn off a group summary:
    • Click any heading in the group
    • Select Delete Row Summary or Delete Column Summary from the context menu.
  • To select the summary function and data format for a measure
    • Click an instance of that measure in the top-most row
    • Select from the context menu.
  • The summary functions for numeric fields are:
    • Maximum
    • Minimum
    • Average
    • Sum
    • Distinct Count (number of different items in the row or column)
    • Count All (total number of items)
• On the Crosstab tab, by default, the editor only displays a smaller, sample set of the data in your crosstab. Click to view the full set of data.
• Many of the layout and formatting options set manually in tables are set automatically in crosstabs. In particular, row and column sizes are fixed.