Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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?
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
I think you can create ValueList() kind of dimensions that could be hint for you.
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.