Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 08:51 PM.


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