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.
|