Count Number of Employees Per Month Using Pivot Table Excel 2010

**mclarke** · 05-25-2017, 02:23 PM

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

**ChemistB** · 05-25-2017, 03:14 PM

Need to see how your data is set up. Create a small fictitious example in Excel and upload the spreadsheet so we can see what we are working with. (Go Advanced>Manage Attachments) Hopefully not everything is in the same column like in your example above.