There are several ways to drill on a grid or chart, and the results may differ with the method performed.
![]() |
If you right-click a data cell to drill down, you will be asked to select a dimension member from among the dimensions that define the selected data cell. |
By default, the Drill Down action drills to the next generation. To change the member level that appears after the drill, select Options... from the right-click menu. This brings up the Data Options dialog box that allows you to specify details of the drill down behavior as well as other options such as whether to suppress missing data.
![]() |
If the grid and chart are synchronized (e.g., viewed in a PresentBlox), drilling on one affects the other. |