I want to list all the users and groups they are member of in one table, one row per user.
I have a simple view that lists all users in the system. I added relation to group content membership and a "Parent group" field to the view.
I tried aggregation, but no luck.
Lets say we have 3 users (user1, user2 and, user3) and 3 groups (Interest1, Interest2, and Interest3). user1 is not a member of any group; user2 is member of Interest1; user3 is member of Interest1 and Interest2.
What I want to see is the following.
What I get is instead this.
I also don't see multiple configuration ("Multiple field settings") or something similar in the group field settings.