Comparing Features of Tables and Crosstabs

The following table compares features of a table and a crosstab.

Feature

Table

Crosstab

Display of data

For viewing as it is stored in a relational database

For analysis

Row header cells

Label records numerically

Provide information about the data

Nesting headers

Not available

Available

Pivoting items on the row edge

Items on the row edge cannot be moved to the column edge or the page edge. Items from the column edge or the page edge cannot be moved to the row edge

Items from any edge can be moved to any edge

Pivoting items on the column edge and items on the page edges

Items on the column edge can be moved to the page edge. Items on the page edge can be moved to the column edge

Items from any edge can be moved to any edge