i am facing a issue on bar chart.since i am not able to say it may be possible or not
i created bar chart in that i want to drill through to filed level values
after creating above bar chart .when i click product d ..when i click on PRODUCR D i want to display all PRODUCT D types as well values in same chart.
BELLOW OUTPUT I WANT TO SEE AFTER CLICKING PRODUCT
after that when i click ant product types i want main chart to display like first chart
Please suggest me if it possible using macros or creating variables or some other process