SOLVED

Pivot table grouping

Copper 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

@muna950 

It groups as

image.png

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 (Copper Contributor)
Solution

@muna950 

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

1 best response

Accepted Solutions
best response confirmed by muna950 (Copper Contributor)
Solution

@muna950 

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?

View solution in original post