Drill down using inline values

[nkosinde13]

Good day Community

I have another question. 

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. 

Please assist urgently.

Regards

Matlotlo

[Anil_Babu_Samineni · Accepted solution]

What is the measure you are going to use? If it is coming from different fact and dimension tables obviously It doesn't makesense to me since there is no associate as It is island table.

If my understand is wrong, can you re-phrase the question?

[nkosinde13]

Thank you @Anil_Babu_Samineni .

That was the problem, that it is an island table. I thought there was a way I could somehow link it to the dimensions being used in the pie charts but that was not the case. 

Regards

Matlotlo

[Anil_Babu_Samineni]

I think you can create ValueList() kind of dimensions that could be hint for you.

[nkosinde13]

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.