Forum Discussion
Group rows within some categories
Hello, I have a table like below: District || Age || Year || Population Jacksonville || 0 || 2017 || 4891 ............ ...
Ok. Since your bins don't seem to be the same size, you can't do a simple rounding to get them. The simplest way might be to make a table with 90 rows for each age and their associate bin, and merge that into your query on the Age column. You can then do a Group By step to get the sum of the newly added Bin column.
Pat
Ok. Since your bins don't seem to be the same size, you can't do a simple rounding to get them. The simplest way might be to make a table with 90 rows for each age and their associate bin, and merge that into your query on the Age column. You can then do a Group By step to get the sum of the newly added Bin column.
Pat
Hello Pat,
I did as instructed and it has worked well for me. Thanks! 🙂
Cheers,
P-