Hi all,
Say for a particular column called Team, I have teams A to E and in each team I have 10 members.
I want to use the Totals option using Group by Teams to sum up the number of members where the criteria would be
1. A - 10
2. C - 10
3. B and D - 20
4. E - 10
Is it possible? I tried using Where, but it didn't work.