Pivot table grouping

Occasional Contributor

Hello. when im grouping age in a pivot table by 10, it groups as 0-10, 10-20 instead of 0-9, 10-19 . Anyone know how to fix this?

9 Replies

@muna950 Did this on a Mac. Should work similar on a Windows PC. Example attached.

Screenshot 2021-01-16 at 14.20.00.png


It groups as


Thank you but the same process for me groups them into 0-10, 10-20 instead of 0-9, 10-19 Screen Shot 2021-01-16 at 4.38.14 PM.pngScreen Shot 2021-01-16 at 4.38.23 PM.png@Riny_van_Eekelen 

Thank you @Sergei Baklan , but the grouping is not the same for me. Kindly look at my other reply.

@muna950 Get the same result when the numbers to be grouped contain decimals. Don't really know why? 

Best Response confirmed by muna950 (Occasional Contributor)


Oh, yes, if numbers have decimals PivotTable groups by such way. With that

0-10 means from zero and less than 10

10-20 means more or equal to 10 and less than 20


I don't remember I've seen workaround for that. On the other hand that's logical. If, for example, you have 9.5 and groups 0-9; 10-19 in which group will be 9.5?

Thank you so much @Sergei Baklan Yes, that makes a lot of sense.

Thank you @Riny_van_Eekelen . Someone explained that it is due to the decimal points as well so i may have to consider rounding them off.

@muna950 , glad to help