Drill page

This page displays the information to enable you to perform a drill by specifying the drill details and applying the drill to the current worksheet.

Note: This page is not displayed when using an OLAP connection.

Hint: To display this page you use the Tab key to highlight a worksheet cell heading that has an arrow icon (that is, a drill icon) then use the Return button.

For more information, see "Worksheet Display page: (Page level tools and controls)".

From

This read-only area displays the name of the item being drilled from (for example, Product Type).

To

This area displays fields that enable you to select the Type of drill, the hierarchy and the item you want to drill to.

Type

Use this drop down list to select the Type of drill that you want to use (for example, Up/Down, Related Item).

Hierarchy

Use this drop down list to select the hierarchy that is being drilled into.

Apply

Use this drop down list to apply the drill details specified on this page and display the result of the drill in the worksheet.