PivotTable - Uneven Grouping

[sallymac]

My PivotTable has a field "Age" (of employees). I need the field Grouped, but not by even intervals as Excel allows.
Eg < 15
15-24
25-39
40-54
55-64
>= 65
Is it possible?

Thanks for your help.
Sally

 

[RoryA]

You have to do the banding in the source data for that, unless you want to manually group each entry. I prefer to use a lookup table and formula in the source data as it's much easier if you need to alter the groupings.

 

[Mike Blackman]

Hi,

You'd need a new row in your raw data to bucket the ages, something like this would give them there attributes...

=LOOKUP(A1,{0,"0-5y";6,"6-10y";11,"11-20y";21,"21+y"})

Then refresh the data picking up the buckets and put the field in the Columns part of the table.

Hope this helps.

 

[Ruddles]

Create an additional column holding the age group.

 

[sallymac]

Thanks very much everyone - I feared as much.
As I am creating a template to come straight from the HRMIS, I was hoping to avoid having to do any manipulation. Possibly I can create a calculated field in the pivot template.
Thanks again
Sally