Custom grouping for pivot table of ages
We have a list of employees with various information among which is birthdate. I made a pivot table that groups and counts the number of employees for each birth year.
Someone wants these to be further grouped by the generation to which they belong e.g. Boomers (1946-64), Gen X (1977-84), etc.
I tried a inserting a timeline, but that's kind of a pain in the butt to use. Any other ideas?
|