Forum Discussion
Pivot table grouping
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?
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?
9 Replies
Thank you SergeiBaklan , but the grouping is not the same for me. Kindly look at my other reply.
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?
muna950 Did this on a Mac. Should work similar on a Windows PC. Example attached.
Thank you but the same process for me groups them into 0-10, 10-20 instead of 0-9, 10-19 Riny_van_Eekelen
muna950 Get the same result when the numbers to be grouped contain decimals. Don't really know why?
