How to use both SUM and COUNT
Content
Hi,
We have custom field for a contact called department. It's in the format:
DEPARTMENT.TEAM
I've split this successfully into two columns. The 3rd column does a COUNT(*) showing how many unique teams there are. How would I also add a SUM to show the departments
Let's say we had:
DEPT1.TEAM1
DEPT1.TEAM2
DEPT1.TEAM3
DEPT2.TEAM4
The output would be:
DEPT | TEAM | DCOUNT | TCOUNT
DEPT1 | TEAM1 | 3 | 1
DEPT1 | TEAM2 | 3 | 1
DEPT1 | TEAM3| 3 | 1
DEPT2 | TEAM4 | 1 | 1
Any advice?
Tagged:
1