Pivot Table-Count of groups

[ssalazarjr]

I need to count how many groups are in a table using a Pivot Table. For example, if I have a column of employees:

John
John
Nancy
Steve
Nancy
John
Eric

I need to get the number of employees down the column (not the count of how many times an employee appears).