Hello, I am working on a dashboard and this is my requirement. I have a drill down ok, so if i click on the highest level of data in a combo box, it populates all the values in the next combo box. ok that part is working. i want to be able to show those rows on the dashboard too. one of sdners told me to use spread sheet table. but i can not control its lenghth and cells, also the data comes this way on excel sheet.
when user clicks on the 1st combo box, data comes in Cell E through G
when user clicks on second combo box, data comes in Cell F through G
and so on.
I can see the data movement correctly but i want to show this on the dashboard as well. How can i do that?