![]() |
|
#1
|
|||
|
|||
![]()
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 | 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 |
![]() |
Dana-H | Excel | 1 | 02-23-2017 12:20 AM |
![]() |
differentdrummer | Excel | 3 | 12-10-2013 01:19 AM |
![]() |
differentdrummer | Excel | 2 | 12-04-2013 03:07 PM |
![]() |
mskennedy | Excel | 2 | 02-27-2013 11:09 AM |