|
|
#1
04-23-2020, 11:28 AM
|
|||
|
|||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot Table - Problem with grouping data (need help for my example) | klm | Excel | 1 | 07-17-2017 06:20 AM |
 Grouping Dates in Pivot Table
|
Dana-H | Excel | 1 | 02-23-2017 12:20 AM |
|
Pivot table grouping problem 2 tables need different grouping
|
differentdrummer | Excel | 3 | 12-10-2013 01:19 AM |
|
Pivot table date grouping
|
differentdrummer | Excel | 2 | 12-04-2013 03:07 PM |
|
Grouping Dates in Excel Pivot Table
|
mskennedy | Excel | 2 | 02-27-2013 11:09 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode