Custom grouping for pivot table of ages

p45cal · #1 04-23-2020, 01:49 PM

Sample file please, preferably with an existing pivot.

gebobs · #2 04-23-2020, 02:28 PM

Here you go.

The Actives tab gets updated periodically but I suppose I could add another field in it after the last column that would put everyone into buckets and pivot on that.

p45cal · #3 04-23-2020, 03:08 PM

Quote:

Originally Posted by gebobs

I suppose I could add another field in it after the last column that would put everyone into buckets and pivot on that.

Yes, if you want to have both annual and generation grouping in the same pivot then that's a very easy way to do it. See attached.

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