Drill Down 
You use this function to drill down on member data within dimensions. You can drill down on members in a worksheet, or you can drill down on charts and graphs.
Prerequisites
To drill down on members in a worksheet:
Expansion is enabled in the workbook.
A hierarchy-based dimension is included either in the rows or columns.
To perform graphical drill down:
The source report has a hierarchy-based dimension in the rows and/or columns.
The chart is on its own worksheet, and the worksheet appears immediately after the worksheet with the source data on it.
Features
You can do the following:
You can drill down on members in a workbook. Upon selecting an expansion member, the spreadsheet automatically displays the immediate dependents of that member.
You can create graphical drill downs.
You can drill down on charts and graphs to make your charts and graphs dynamic.
Activities
To drill down on members in a workbook, select the member you want to drill down on and double-click the member ID or the description.
You can use the action pane to both drill down and drill back up.