Working with Crosstabs

About Crosstabs

A crosstab shows the intersections of category values and measure values as text. If your crosstab contains measures, then each cell of the crosstab contains the aggregated measure values for a specific intersection of category values. If the crosstab does not contain measures, then each cell contains the frequency of an intersection of category values.

Specify Properties for a Crosstab

On the Properties tab, you can specify the following option:

Name

specifies the name of the visualization.

Show Column Subtotals

adds subtotals to each column, for each node on the row axis after the first.

Note: Subtotal values are aggregated according to the default aggregations for each measure.

Show Column Totals

adds totals to each column.

Note: Total values are aggregated according to the default aggregations for each measure.

Show Row Subtotals

adds subtotals to each row, for each node on the column axis after the first.

Note: Subtotal values are aggregated according to the default aggregations for each measure.

Show Row Totals

adds totals to each row.

Note: Total values are aggregated according to the default aggregations for each measure.

Totals Placement

specifies the location of totals and subtotals. Select Before to place the totals and subtotals before the axis headings. Select After to place the totals and subtotals after the axis headings.

Data Roles for a Crosstab

The data roles for a crosstab are columns, rows, and measures. You can assign either a single hierarchy or any number of categories to each of the columns and rows roles. If you assign measures to the crosstab, then the measure values are displayed in the cells of the crosstab. If you do not assign measures, then the cells of the crosstab show the frequency of each intersection of values.

Managing Rows and Columns

Sort a Row or Column

By default, the crosstab is sorted alphabetically by the values of the first category that you assign to the Rows role. To change the sorting, right-click the heading for the row or column that you want to sort, and then select Sort

[sort-method].

Note: Sorting is not available for measures.

Rearrange Rows and Columns

To rearrange your rows and columns, drag and drop the column headings.

Resize Columns

To resize your columns, click and drag the left or right edge of the column headings.

Create Hierarchies from a Crosstab

Crosstab visualizations enable you to create hierarchies from the categories on a crosstab axis. To create a hierarchy, right-click a category heading and then select Create Hierarchy. The categories are replaced with a new hierarchy.

The name of the new hierarchy is generated from the name of the outermost category, with the suffix “Hierarchy.”