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.
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.
