In place drill down from PieChart to BarChart

SMA97

<p>I have a Data Cube in my report with a dimension that has two level hierarchy (say L1 and L2).  I also have a single Measure summary field, call it Val1.</p><p> </p><p>I want to be able to use the HTML5 Pie and Bar charts (ideally) to provide a composite drill-down in place.  So, initially you would show L1 aggregation for Val1, using a Pie, and when you click on a pie slice, you drilld-down to L2, and now show the bar chart with L2 data, replacing the pie.  You would, of course, want to be drill-up back to Pie from the Bar chart.</p><p> </p><p>What would be the best approach to accomplish this?</p><p> </p><p>thanks in advance for your suggestions.</p>

BRM

<p>Set a hyperlink for the pie chart that drills to the bar chart you want.  The drill through can be set to render in the same frame.  Then you set the drill through for the bar chart to the pie chart in the same manner.</p>