How to show alternate values in a table when select in field?

[nikita42]

Hi,

I have a table like:

Case#	City
1	London
1	New York
1	New Jersey
2	Miami
2	New York
2	Dublin
3	Mumbai
4	Havana

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.

Any ideas?

[sunny_talwar · Accepted solution]

You can do this in a straight table using set analysis in your expression

{<City, Case# = p(Case#)>}

[nikita42]

Yes! Could you explain what that statement does? I've never seen it before.

[sunny_talwar]

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

[nikita42]

Perfect. Thanks so much!

[sunny_talwar]

No problem my friend