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.

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.