Hi everyone,
I am having trouble of grouping numbers to the range I want, can anyone shed some light? I want to have second range starting from '101'.
0-100
101-500
does it have anything to do with the data? I have tried different starting, ending, and interval... nothing works.
many thanks!
Tina
Hi, Tina,
Can you share a file with your (anonymised) data? Can you also specify the error message you get?
BR,
Lionel
Hi Tina
The grouping interval in Pivot Table must be the same, i.e. 0-100, 101-200, 201-300 (interval of 100, for example) etc.
I would suggest you create a helper column to group your data into the different intervals and only then group the helper column using the Pivot Table.
Hope this helps.
Sunny
hi
I have uploaded a file, can you please share how to group the data in pivot table like below,
0-100
101-200
201-300
etc...
many thanks!
Hi Tina,
Thanks for sharing your file. It's not clear, but I presume you want to group the receipt amounts. If so, please see attached. To create this PivotTable, right-click the row labels in the PivotTable > Group.
Hope that helps.
Mynda
Hi Tina
If the grouping interval is consistent (100) then what Mynda suggest will work for you.
But you mentioned 1-100, 101-500 (different intervals) in your post. Without seeing what are your intervals I can only make a guess.
I have attached one method where the intervals are not consistent.
I used VLOOKUP to extract the grouping from a table.
The row labels in the PT are manually sorted.
Hope this will point you to the right direction.
Good luck.
Sunny
