About pivoting data on a crosstab worksheet

On crosstab worksheets, you can pivot items to and from the left axis and top axis.

Because the data relationships on a crosstab depend on the intersection of the rows and columns, pivoting data from one axis to another creates a new set of data relationships.

In addition, pivoting worksheet data can add levels of data to an axis. For example, if the data on the left axis is organized into three levels (e.g. Region, City, and Store Name), pivoting the Year item to the side axis adds a fourth level of data to that axis.

The figure below shows how you might use the Crosstab layout dialog to arrange worksheet data, by positioning items as follows:

• Calendar Year and Profit SUM items are placed on the top axis

• Department, Region, and City items are placed on the left axis

Figure 9-3 Laying out data on a crosstab worksheet

Description of the illustration piv6.gif