I have an inline table with values : Category, Department,Chart etc... And I have a pie chart with drill down created, drill down dimensions are: Category, Department, Chart.
how do I make the pie chart drill down based on the inline selection same way it would if I drill down on the chart itself? e.g. If a user selects Department on the inline list, I want the pie chart to also drill down to Department.
Thanks for the suggestion @Anil_Babu_Samineni but I'm using the inline table as a list box for conditional show & hide of dimensions for pivot tables and wanted to use the same for pie chart drills. So I cannot have 2 listboxes as these are on the same tab.