Drill or Expand Hierarchies in a Graph
You can drill in a graph
that is based on multidimensional data. Right-click the name of a
member in the graph, and then select Drill down on <member>.
You see only the values for the next hierarchy level down for that
member.
Note: If a section is synchronized,
then a graph that exists in a synchronized section with a table expands
if an expand operation is performed on the table. For more information
about synchronization, see Overview of Synchronized Filtering, Sorting, Drilling, and Expanding.
In the Hierarchy Level Product, the Member Clothes & Shoes
Has Been Drilled to Display Values for the Shoes Hierarchy Level
In In the Hierarchy Level Product, the Member Clothes & Shoes Has Been Drilled to Display Values for the Shoes Hierarchy Level, to undo the drilling, you select Clothes &
Shoes above the graph, which is the next hierarchy level
up. To go back to the top level of the hierarchy, select Product.
Note: You cannot drill into the
X-axis category values for a progressive bar chart with a multidimensional
data source if the chart includes an initial or final bar. However,
you can still drill into the chart. You can remove the initial and
final bars, drill into the chart, and then add back the initial and
final bars. If your section is synchronized, you can drill into a
different report element, because the drills are shared across report
elements in a synchronized section. You can also drill into any horizontal
or vertical series data items, because only the X-axis category value
has drilling restrictions.