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.

Data Roles for a Crosstab

The data roles for a crosstab are columns, rows, and measures. You can assign any number of categories to 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 Sortthen select[sort-method].

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.