About drilling to related items

You drill to a related item to add a related item to the worksheet. For example, if you select Department, the Department item is added to the worksheet. Related items are items that are not currently in the worksheet but are in folders used by the worksheet. The item you drill to does not have to be in the same drill hierarchy as the item you drill from.

In the example below, you want to add information on sales bands to a worksheet. Although you could do this by editing the worksheet to add the Sale Band item to the worksheet, you can also use the drill menu to quickly add this information.

Figure 10-4 Drilling to a related item

Description of the illustration drill4.gif

You can drill to a related item from worksheet data, but not from graph data.

For more information, see "How to drill to a related item".