I have a table like:
When I select the city London, I can only see the top row as expected, but is there a way to display the other cities associated to case 1?
Basically, I need to show all cities that share a case with the selected city. So, if I select New York, I want to see all rows for Case 1 and 2, but none of the rows for case 3 and 4.
It ignores selection in City field... so will disregard selection in London, but will look at all possible values of Case# based on selection in City field. So when you selected London, only possible value for Case#1, so the chart will display all cities (if city is your dimension) where Case# 1 is possible