I am creating a dashboard from Excel.
I have a Pie Chart which has Americas, EMEA and APAC.
But every Americas, EMEAs and APACs have cities. Users wants the drill down. If they click on Americas in pie chart, then it will show values for the relevant cities for Americas.
What is the best way to do this ?
Developer_Designer (BOB member since 2009-08-09)
Did you not spot the drilldown tab in the chart properties?
Other similar effects can be gained using the Filtered Rows functionality.
ABILtd 
(BOB member since 2006-02-08)
I still could not find Drill Down option. Where is it ? Right side, I could not find any drill sown option under General, Insertion, Behavior or Appearance tab.
Developer_Designer (BOB member since 2009-08-09)
It depends on the version of Xcelsius\SAP Dashboards you have and the chart type you are using. I don`t have SAP Dashboards installed to check here. Place some charts on the canvas and have a look through which have drilldown properties.
ABILtd (BOB member since 2006-02-08)
It’s also fairly trivial to do this with the Insertion properties. Insert the selected region into a cell (unfortunately pie charts don’t seem to support Filtered Rows). When that cell is updated, refresh a query to pull in the cities and their data into another table. Base your child graph on that table.
Lugh (BOB member since 2009-07-16)