Help needed in identifying records

[#1]

I have three tables Players, Team, Plays

i want to know the Players who plays for same Teams. In my attached qvw PLayerID 2 and 3 plays for same Teams, Playerid1 also plays for the same teams but PlayerID 1 also plays for other teams.

So i want to know the Players who plays for same teams like PLayerID 2 and 3

[#2 · Accepted solution]

Hi,

I using a concat function to get a SameTeam identifier, for example Players 2 and 3 play in teams 1 and 3 so IdSameTeam is 13 and then to identify IdSameTeam with two players or more... use a list box and check "Show Frecuency" or use a pivot table with IdSameTeam, PlayerName as  Dimension  and if you want count(distinct playername) as expression.

See attached file.

Regards.

[#3]

Awesome Idea Thanks alot