Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2020, 11:28 AM
gebobs gebobs is offline Custom grouping for pivot table of ages Windows 7 64bit Custom grouping for pivot table of ages Office 2010 64bit
Expert
Custom grouping for pivot table of ages
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default 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?
Reply With Quote
  #2  
Old 04-23-2020, 01:49 PM
p45cal's Avatar
p45cal p45cal is offline Custom grouping for pivot table of ages Windows 10 Custom grouping for pivot table of ages Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Sample file please, preferably with an existing pivot.
Reply With Quote
  #3  
Old 04-23-2020, 02:28 PM
gebobs gebobs is offline Custom grouping for pivot table of ages Windows 7 64bit Custom grouping for pivot table of ages Office 2010 64bit
Expert
Custom grouping for pivot table of ages
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Here you go.

The Actives tab gets updated periodically but I suppose I could add another field in it after the last column that would put everyone into buckets and pivot on that.

Last edited by gebobs; 04-24-2020 at 08:52 AM.
Reply With Quote
  #4  
Old 04-23-2020, 03:08 PM
p45cal's Avatar
p45cal p45cal is offline Custom grouping for pivot table of ages Windows 10 Custom grouping for pivot table of ages Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by gebobs View Post
I suppose I could add another field in it after the last column that would put everyone into buckets and pivot on that.
Yes, if you want to have both annual and generation grouping in the same pivot then that's a very easy way to do it. See attached.
Attached Files
File Type: xlsx msoofficeforums44797Sample.xlsx (47.2 KB, 6 views)
Reply With Quote
  #5  
Old 04-24-2020, 01:40 AM
ArviLaanemets ArviLaanemets is offline Custom grouping for pivot table of ages Windows 8 Custom grouping for pivot table of ages Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

From your post follows, generations are defined on base of birth year, not on base of age.

On sheet Generations, generations are defined. Generation name is read from there based on it's position there. Generation name is added as calculated column into Activities table (it's up to you, do you hide this column or not). And then you can use this column for grouping of pivot.
Attached Files
File Type: xlsx GenerationGrouping.xlsx (84.0 KB, 8 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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
Custom grouping for pivot table of ages Grouping Dates in Pivot Table Dana-H Excel 1 02-23-2017 12:20 AM
Custom grouping for pivot table of ages Pivot table grouping problem 2 tables need different grouping differentdrummer Excel 3 12-10-2013 01:19 AM
Custom grouping for pivot table of ages Pivot table date grouping differentdrummer Excel 2 12-04-2013 03:07 PM
Custom grouping for pivot table of ages Grouping Dates in Excel Pivot Table mskennedy Excel 2 02-27-2013 11:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft