Hi,
I want to have a bar chart drill down to a table on a dashboard but unable to get it working.
I have attached the layout of the dashboard with example data.
Do i need to define the groups of data in order to get it to work?
Any help would be appreicated! 
Drill Down.xls (70.0 KB)
DecT91 (BOB member since 2012-12-04)
This is pretty simple.
Using the “Insertion” option of the bar chart, capture the label of the selected value in an excel cell(A1).
Use a combo box with labels as Customer A, customer B, Customer C, Customer D.
The source of the combo box should be your entire Data B table.
Give a destination range also. Make sure you use filtered rows option for the “insertion type” in combo box.
Go to the “behavior” of the combo box, and map the default selected value option to the cell A1.
You should be good with this.
Let me know if you need something else
Naveen.SAP (BOB member since 2012-11-16)