How to pivot worksheet items in the Discoverer work area

You pivot worksheet items in the Discoverer work area to rearrange items on a worksheet. For example, you might want to move a Department item to the Page Items area so that you can analyze individual departments.

To pivot worksheet items in the Discoverer work area:

1. Display the worksheet that you want to analyze.

2. Select the grab handle of the worksheet item you want to pivot.

   
   Description of the illustration piv_tab.gif
   
   

3. Drag the grab handle to the required position and release the mouse button.

   Hint: When you drag and drop items, a black line shows the item's new position on the worksheet.

   
   Description of the illustration piv_tab2.gif
   
   

Discoverer repositions the worksheet item as you specified.

Description of the illustration piv_tab3.gif