Forum Discussion
EileenVeg4256
May 03, 2022Copper Contributor
Excel Pivot Tables
Hi - If you have a group of ages in a Pivot table eg 1 - 50 but you don't want to show them all, there is a way of grouping the ages into 1 - 10, 11 - 20, 21 - 30 etc. I have used this feature in the past but cannot find it in 365 - has it been removed or am I missing it? I seem to remember that you select the field, right-mouse click the field and select Group from the options given - but I cannot see it! I would appreciate any help on this please. Thanks
1 Reply
- EileenVeg4256Copper ContributorDon't worry folks - I've answered my own question - grouping has moved to the Ribbon with several buttons on the Group set of buttons. Thanks all. I'll be back with more questions and answers.