Use set analysis to get own group among all groups

[fionna51]

Hi guys,

Please help me write this set analysis, please use the sample testapp I uploaded.

In this app, entity related to different groups, and they have ranks within own group. What we want to do is if I select any one entity, I want to see ranks for the group related to selected entity. For example if I select COMM2, I should see group A ranks. (select COMM1, 3, and 4, should display same ranks)

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

Try this expression in a straight table with entity and group as dimensions: max({<entity,group=p(group)>}rank)