Conditional Show an object by clicking on other object
Hi,
It would be great if I can get some suggestions regarding the below mentioned requirement:
I have a bar chart where I am using 2 dimensions: Customer , Quarter
and one expression : Sum(Value)
Requirement:
1. I want to create a straight table which will have the same expression but the dimension would be Months instead of Quarter. I am not allowed to create a cyclic group. Also, this straight table will be populated when a dimension bar is clicked for the particular customer and a particular quarter.
2. The straight table should be placed on a text box as it makes it more readable (Must by the end user).