Drilling through Hierarchical Data
If hierarchical dimensions are included in a chart, you can drill up or down through
dimensions to explore the data at different levels.
Context
If the chart contains more than one hierarchical dimension, you can select which dimension to
drill into.
Procedure
-
Select an area in the chart or a label on the axis.
For example, you can select one or more bars in a bar chart.
The selected area in the chart is highlighted.
-
Right-click and select
Drill Down or
Drill Up, and then select the dimension to drill
on.
You can also show all levels of the hierarchy by choosing
Expand/Collapse.
-
To remove or reset the drill option, in the title area for the chart select
Reset Drill and then choose which dimension to
remove.