Jan 16 2021 04:46 AM
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?
Jan 16 2021 05:21 AM - edited Jan 16 2021 05:23 AM
@muna950 Did this on a Mac. Should work similar on a Windows PC. Example attached.
Jan 16 2021 05:40 AM
Thank you but the same process for me groups them into 0-10, 10-20 instead of 0-9, 10-19 @Riny_van_Eekelen
Jan 16 2021 05:42 AM
Thank you @Sergei Baklan , but the grouping is not the same for me. Kindly look at my other reply.
Jan 16 2021 06:09 AM
@muna950 Get the same result when the numbers to be grouped contain decimals. Don't really know why?
Jan 16 2021 06:18 AM - edited Jan 16 2021 06:20 AM
SolutionOh, 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?
Jan 16 2021 07:53 AM
Thank you so much @Sergei Baklan Yes, that makes a lot of sense.
Jan 16 2021 07:54 AM
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.
Jan 16 2021 06:18 AM - edited Jan 16 2021 06:20 AM
SolutionOh, 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?