Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a file with a stacked bar chart and I would like to add a drill down. The stack would show the values of finished goods and parts stacked by month. Then I would like to drill down when selecting either finished goods or parts for the month of march that would show our warehouse. Currently I can only get it to go from the months with the stacks to just the month with the stack.
if you clikc on one bar you first get the month, next click will get you the finished goods
alternatively you can select the finished goods from the legend
then you get the selected finished good over all months
That's what happens now, but I want to be able to click either the top or the bottom of a bar and it take me directly to the next level which in this case would be warehouse.