Counting Unique Records in a report

[sirmanson]

I have a report that groups employees by their supervisors. Each of these groups has some totals that need to be multiplied by the number of employees in this specific group. If I use the COUNT function it shows the total number of records (136) instead of (6).

I tried modifying the column to be CountDistinct but it turns blank when I do this. Any ideas?
Thanks,
Aaron

 

[iamthenewnumbertwo]

Sort data by Supervisor and Staff member.
Create computed column "computed1", concat (supervisor, staff member)
Create computed column "computed2", if (computed1 != next(computed1)) {1} else {0}
then do your sums on computed2