About pivoting worksheet items

You pivot worksheet items to arrange data on a crosstab worksheet for more effective analysis. For example, on a crosstab worksheet you might move an item from the left axis to the top axis to analyze new data relationships.

Pivoting is a powerful analysis tool enabling you to explore data relationships that might initially be hidden.

You can pivot worksheet data in the following ways:

• in the Discoverer work area, you can drag and drop a worksheet item heading into a different position and see the new data layout instantly

  In the example below, the Department item is dragged from the left axis to the top axis in the Discoverer work area.

  Figure 9-1 Pivoting in the Discoverer work area

  
  Description of the illustration piv8.gif
  
  

  For more information about pivoting worksheet items in the Discoverer work area, see "How to pivot worksheet items in the Discoverer work area".

• in the Edit Worksheet dialog (i.e. in worksheet design mode), you can drag and drop a worksheet item into a different position and see the new data layout when you close the Edit Worksheet dialog and display the Discoverer work area.

  In the example below, the Department item is dragged from the left axis to the top axis using the Edit Worksheet dialog: Table Layout tab.

  Figure 9-2 Pivoting in the Edit Worksheet dialog: Crosstab Layout tab

  
  Description of the illustration piv9.gif
  
  

  For more information about pivoting worksheet items using the Edit Worksheet dialog, see "How to pivot worksheet items using the Edit Worksheet dialog".