|
|
#5
04-24-2020, 01:40 AM
|
|||
|
|||
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. 
|
| 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 |
 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 8 
Office 2016
Threaded Mode