Have one requirement is that have one straight table:
Now the requirement is that on click of All Items, it should display all the dimensions.
If we click on exceptions should show only dimensions where variance column BG colour was Yellow & Red BG .
PFA sample QVW. !
Thanks for your quick reply.
Will try to implement the same in my dashboard.
Have one more issue is that, if I select any metric in table other metrics should also be visible. it should not hidden.
Is there a way to achieve the same.
Thanks in advance for your support.
Implemented your logic and its now working as per my requirement.
Once can please explain what exactly happening in the given logic. Just to understand.
please correct me if I am wrong.
We are making all Green & Grey(Which ever we need to hide) to null and restricting in table level is that correct.?
The expression you provided is working fine, but we are facing an issue in our main application while accessing in access point.
Like, since its an calculated dimension with aggregation function it have so many if conditions with some set analysis conditions.
Its taking so much of time and consuming large amount of RAM in our access point, can please let me know is there any alternate solution instead of aggregation function.
Thanks in advance.