cross-filtering between multiple tablets

[Nishantp]

Hello, I am not getting any success for creating a cross-filter which will allow me to do the following..

I have one table that has all the user data such as name, address, etc. and the unique identifer is UserId

I have another table that has all the movies that user said they like. This table has multiple rows for each UserId

I have yet another table that has all the cities that user said they want to visit. This table also has multiple rows for each UserId

I want to set cross-filtering in a way that i can click on any city and it will filter everything (in all three tables) where only Users who selected that city show up and movies only for users that selected that city show up.

I can do cross-filtering between User table and movies or cities table but after I have done one cross-filter with two way filtering, and then I try to do that with second table it says there already is a 2-way cross filter set for User table and you can't have more than one such filters per table.

How do we solve this? What if I want to click on a movie and woudl like to see all the users who picked that movie and also all the cities that those users selected...I should be able to click on any movie, city or user name and everythign across all the three tables shoudl be filtered accurately

Thoughts? 

[parry2k · Accepted solution]

@Nishantp you should able to achieve it, seems like some other relationship in your model is not letting you do this