Working with Crosstabs
Crosstabs are a type of data container that operates on aggregated data. The row and
column fields in the crosstab are typically string fields or enumerations while the intersection of
the crosstab must always be a summarized piece of data, typically a numeric value.
You can see three areas in the crosstab object:
- Columns
- Data items placed here will generate column headers. Multiple data items can be dropped here to create nested column headers.
- Rows
- Data items placed here will generate the rows of data in the crosstab. Multiple data items can be placed here to generate nested rows.
- Measures
- Only a single data item can be placed here that will be aggregated against the rows and columns selected.