I got asked today if it was possible to return just those users who had one group and that group was the main group. I wasn’t able (yet) to use the count function in the filter so what I did was this:
I returned UserNo, keyCount (count of UserAccount,Groups,Name).
I added a filter to equal the string main group.
In the resultant file, the users who had a count of 1 would only be in the main group.
This isn’t ideal but it does give a list of those who are only in the main group with a little massaging. Attached it the export file for this process.