Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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, 10 views)
Reply With Quote
Reply



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 09:09 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