Guys,
I need help with a pivot table I am trying to do an employee breakdown based on years of service.
However I want it broken down like below
1-5
5-10
10-15
15-20
20+
if I do "Count of classification" it gives me 116 (which is my total employees).
if I do "Average years of Service" it gives me the years of service per classification.
However I already have that chart. I am trying to make it show a different way and I dont have fields for 1-5 5-10 10-15 etc
I want it to look like below
1-5 - 48
5-10 - 31
10-15 - 8
15-20 - 11
20+ - 18
total - 116
how could I do this?
Matt
Bookmarks