Tired Chart

[#1]

Hi All,

I currently have a stacked report that has two dimensions (created date, and root cause) problem I am having is Root Cause is the top level out of 3 fields.

     Root Cause

          Subject

               Item

What I am trying to do is when someone selects a root cause, the chart updates to show all the sub items under it, and then the same with filtering down to the item in the same chart.

[Gysbert_Wassenaar]

Create a Drill-down group with those three fields. Then use that group as dimension in your chart instead of root cause. You can create groups on the Dimensions tab of the charts properties window and on the Groups tab of the Document Properties window.

[MK_QSL · Accepted solution]

Search for Drill Down Group.. this will serve your purpose..

Creating Cycle and Drill Groups