Hi All
I have a table with a list of domains and the groups and users that have accessed them. Not all groups/users have accessed every domain. I'm trying to create a query which will list each domain and include all 4 groups (Staff, Student, Generic, Other) - and 0 in the "User" count column where there was no access by users. For example...
Table...
DOMAIN GROUP USER greattrains.com Staff abcde1 greattrains.com Student abcde2 greattrains.com Staff abcde5 greattrains.com Generic abcde3 greattrains.com Other abcde4 thinkific.com Staff abcde5 thinkific.com Generic abcde6 thinkific.com Other abcde7 wiley.com Other abcde4 wiley.com Staff abcde8 wiley.com Other abcde9
Expected query results...
DOMAIN GROUP USER greattrains.com Staff 2 greattrains.com Student 1 greattrains.com Generic 1 greattrains.com Other 1 thinkific.com Staff 1 thinkific.com Student 0 thinkific.com Generic 1 thinkific.com Other 1 wiley.com Staff 1 wiley.com Student 0 wiley.com Generic 0 wiley.com Other 2
I have tried to find something in search but I'm having no luck.
Can someone please help me with achieving this?
Many thanks
darls15