Need an urgent help.
Say I have two fields like Location and Attended_PeopleStatus where location field will have duplicate values.
Now I want the count of distinct status according to Region.
Output Count of Attended_PeopleStatus should be:
0 - 3
1 - 4
Can anyone please advice how can i achieve this.
May be like this