Comparing two selections in one table

[florianmay]

Hello!

I load data from active directory and made a table like this:

User	Group
U1	G1
U1	G2
U2	G1
U2	G3
U2	G4
U3	G3

Now i want to compare the groups of two users. In best case i want a field or table, which only shows me the rows with different groups.

For example, I compare U1 with U2:

User	Group
U1	G2
U2	G3
U2	G4

Is it possible to compare two selections like this?

best regards,

Florian

[YoussefBelloum]

Hi,

on your second table, are missing the line: U1, G1 ?

[florianmay]

U1->G1 and U2->G1 should not be shown, because both users are members of G1

[YoussefBelloum]

Hi stalwar1‌

I'm stuck on this one, when you have some time to help please take a look

[sunny_talwar · Accepted solution]

May be using a set analysis like this?

{<Group = {"=Count(DISTINCT User) = 1"}>}

[YoussefBelloum]

Perfect !

[florianmay]

Thanks, this works great.