Drilling through Waterfall Charts

If hierarchical values are included in a waterfall chart, you can expand or collapse the chart to explore the data at different levels.

Procedure

Select an area in the chart or a label on the axis.
The selected area in the chart is highlighted.
In the menu that appears, do one of the following:
- Chart has only one Account measure: select (Expand Account or Collapse Account).
- Chart has a measure and one or more dimensions: select (Expand or Collapse) and from the list, select the measure or dimension.
- Set one or more data points to be the intermediate or total sum: select ().
To remove the drill option, in the title area for the chart select (Set Drill) and then choose (Reset).