In a pie chart containing only two metrics, user wants to click on one metric and the bar graph will return the top 10 customer based on that metric.
ACTION:
Follow the steps below to implement the above feature in in Strategy Web 9.4.1:
1. Create a dataset report.
2.Create a document. Add a grid with Profit and Cost in rows.
3.Create separate graphs for customer*profit and customer*cost
4. Apply view filter accordingly
5. Configure Metric in the first grid as selector targeting at two graphs.
6. Configure the grid as pie chart.
7. Change pie chart setting to "Series by Row" (in Editable mode, Click graph, on the toolbar choose "Series by Row")
8. Change the two bar graphs format: Maximum Categories=10
9. Now go to developer, project configuration--report definition--advanced--no data returned, change to hide document grid.
10. Restart IIS (This is important for step 9 to take effect)
11. Put the two bar graphs together in same position as if they are same graph.
In editable mode, click on cost:
Click on profit:
