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 Sort[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.