Hello Everyone,
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.
| Location | Attended_PeopleStatus |
|---|
| A | 0 |
| A | 0 |
| B | 0 |
| C | 0 |
| C | 0 |
| C | 0 |
| C | 0 |
| D | 1 |
| D | 1 |
| E | 1 |
| F | 1 |
| F | 1 |
| F | 1 |
| G | 1 |
Output Count of Attended_PeopleStatus should be:
0 - 3
1 - 4
Can anyone please advice how can i achieve this.
Thanks,
Ipsita
