Custom grouping for pivot table of ages

gebobs · #1 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 · #2 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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