How to drill to detail

You drill to detail to analyze all worksheet items in a folder or to analyze the individual rows that make up summary values. For example, you might want to drill from a worksheet item called Month to analyze a folder called Monthly Sales Analysis in a separate window. Or you might want to click on a summary Sales value and analyze the individual values that contribute to the sales total.

To drill to detail:

1. (optional) Select the worksheet item you want to drill from.

2. Choose Tools | Drill to display the "Drill dialog".

   
   Description of the illustration ddrill18.gif
   
   

   Hint: You can also display the Drill dialog by right-clicking on a worksheet cell and selecting the Drill... option.

3. Select Drill to Detail from the Where do you want to drill to? drop down list.

   
   Description of the illustration ddrill20.gif
   
   

   The list shows the Drill to Detail options available.

4. Select a Drill to Detail option from the list of available options.

5. (optional) If you want to change the default worksheet style for the Drill to Detail data, click Show Advanced and select a worksheet style from the Advanced options.

6. Click OK.

   Discoverer displays the folder you selected in a new worksheet (unless you changed the advanced settings on the Drill dialog). If you want to save the new worksheet, you must save the Discoverer workbook (for more information, see "How to save workbooks").