How are crosstabs structured?
You can use crosstabs to analyze any number of measures in terms of any number of dimensions.
A crosstab has the following components:
Measure field
Contains the measure calculated in the analysis. The measure values are displayed in the data fields.
Row field
Field to which a row alignment is assigned. A row field contains a dimension or measure you are using as a dimension. The dimension values are displayed as the row label.
Column field
Field to which a column alignment is assigned. A column field contains a dimension or measure you are using as a dimension. The dimension values are displayed as the column label.
Dimension values
The dimension values are displayed as the column or row label.
Measure values
Contains calculated measure values or measures that are each displayed in a measure box.
Overall result
Contains the calculated results for the measure values in the individual rows and columns.