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?