...
| By default, a crosstab displays a subset of the data its query retrieves. Click Full Data to view the full dataset. This can be helpful in showing a more accurate view of the final view (by showing more data). Click Sample Data or No Datato improve performance if you find the editor has slowed down. |
Component
Description
Columns area
Drag dimensions and measures from the Data Selection panel to this area to create column groups. Drag fields to change the order of the groups. Measures must all be in the same area; you cannot have measures in the Columns and Row areas at the same time.
Rows area
Drag dimensions and measures from the Data Selection panel to this area to create row groups. Drag fields to change the order of the groups. Measures must all be in the same area; you cannot have measures in the Columns and Row areas at the same time.
Row and column
group labels
Displays the name of each field used for grouping. Right-click the group labels to use the context menu. When no row groups are defined, the words Row Group indicate this vertical region.
Row and column group values
Heading cells that show the group values. When there is more than one level of grouping, use the icons on the outer groups to expand or collapse the inner groups. Right-click a group value to exclude it or to keep only that value from among all group values of the same level.
Sorting controls
An icon beside a label shows the current sorting. Right-click a label to apply or change sorting. You can sort on multiple groups, but only one measure; sorting on a measure will reset all other measure columns to Don’t Sort.
Measure labels
Display the name of each measure in the crosstab. Right-click the measure label to change the summary function or data format of the measure.
Measures
Measures show an aggregated value in each cell of the crosstab, as well as row and column totals for each level of grouping. Click on a measure value to open an Ad Hoc table view in a new window showing the individual values that make up the aggregated value.
Common tasks when working with Ad Hoc crosstabs include:
...