how to make this pivot table field?

[bigdan]

I have a number of employees that had multiple check-in times. So for example Peter may have checked in 3 times on Jan 1, 2 times Jan 2, 7 times Jan 3 etc. These dates are in the Date column.

I want to create a pivot table which shows an employee and the number of checkins per day. So I'd want something like this:

Peter
1/1	3
1/2	2
1/3	7
Jane
1/1	5
1/2	6
1/3	7

<tbody>
</tbody>

I'm stuck. Can anyone help?

FYI there's no current field in the source data for number of checkins.

Thanks!

 

[SpillerBD]

COUNT the number of check-ins.