Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be using a set analysis like this?
{<Group = {"=Count(DISTINCT User) = 1"}>}
Hi,
on your second table, are missing the line: U1, G1 ?
U1->G1 and U2->G1 should not be shown, because both users are members of G1
Hi stalwar1
I'm stuck on this one, when you have some time to help please take a look
May be using a set analysis like this?
{<Group = {"=Count(DISTINCT User) = 1"}>}
Perfect !
Thanks, this works great.