Forum Discussion
Pivot table grouping
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 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?
Thank you so much SergeiBaklan Yes, that makes a lot of sense.
muna950 , glad to help