Color user who are not in a specified group

[#1]

Hi,

I want to show all user who belong to a specifed domain, but who are not members of specifed group(s). Data model is like this:

UserLogin
UserDomain
UserGroup

So data would look like this:

John, @john.com, Users
John, @john.com, Admins
John, @john.com, Teachers
Anna, @anna.net, Users
Travis, @travis.org, Users
Travis, @travis.org, Admins

So, I've created a pivot table dimensions UserLogin-UserGroup and I would like to color all UserLogins which are not part of a hard-coded group(s). Or, even better, which are not part of one hard coded group or another hard coded group. Or, even much better 🙂 which are not part of any of the groups selected in the "data-island" field which actually holds all "Group" values.

Thnx 🙂