Hello,

I'm just getting my feet wet with pivot tables and have watched videos, read examples with no light bulb going off yet! I'm trying to figure out how to count how many employees are in each month using a pivot table. It is counting the number of entries per person and I've tried switching the value field setting around with no success, is there a way to do what I want to do? I can use an employee number vs employee name if that matters. The names do repeat throughout the months, people leave and new people come.

Below is what I'm trying to accomplish:

May Count 3
Betty Lou
Mary Jane
Bobby Smith

June Count 4
Betty Lou
Mary Jane
Bobby Smith
Joe Blow

Thank you!
Marie