Hello,
I am trying to group numbers in a pivot table by ranges (e.g. <0.5 - 0.5 - 0.9, 1.0 - 1.9, 2.0 - 2.9 etc) but the group selection dialog box will not appear to allow me to set the parameters automatically.
If I continue to do it manually, a new number not currently registered will disrupt the table when the data is refreshed.
Can anybody offer any advice?
Best,
Drew
I am trying to group numbers in a pivot table by ranges (e.g. <0.5 - 0.5 - 0.9, 1.0 - 1.9, 2.0 - 2.9 etc) but the group selection dialog box will not appear to allow me to set the parameters automatically.
If I continue to do it manually, a new number not currently registered will disrupt the table when the data is refreshed.
Can anybody offer any advice?
Best,
Drew