Log In
Register
Home
June 1, 2018
Offline
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
September 9, 2020
Offline
Hi, Tina,
Can you share a file with your (anonymised) data? Can you also specify the error message you get?
BR,
Lionel
VIP
Trusted Members
June 25, 2016
Offline
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
June 1, 2018
Offline
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!
July 16, 2010
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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
1 Guest(s)
