About unexpected results with pivoting

Discoverer makes it easy to pivot data on worksheets. However, it is also easy to produce unexpected results.

For example, on a crosstab worksheet, you must have the following:

• one or more items on the left axis

• one or more items on the top axis

• one or more data points (e.g. Profit SUM) in the worksheet data area

In the figure below, when the Region item on a crosstab worksheet is moved to the Page Items area, the resulting worksheet is empty. This is because you must have items on both the left axis and top axis to analyze data on a crosstab worksheet.

Figure 9-4 Pivoting to produce unexpected results

Description of the illustration piv2.gif