Custom grouping for pivot table of ages

		Microsoft Office Forums > Microsoft Excel > Excel
Custom grouping for pivot table of ages

04-23-2020, 03:08 PM

p45cal

Windows 10 Custom grouping for pivot table of ages

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

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.

Attached Files

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:50 AM.