Forum Discussion
Need help grouping filtered columns into numeric ranges
I have a table showing: and I want to be able to filter in my report by contractor and get the sum of the rows like below: and I would like to put these into buckets of ranges...
ryan_mayu
Super User
Super UserAnonymous
pls check if this is what you want
It should be 8 results for 1-5 and 2 results for 5-10. Sorry for my typo, it should say 10 not 100.
- ryan_mayu
i didn't copy paste all your data since it's a screenshot. you can try my solution on your own data.
apologies, i didn't see the attached pbix file. I tried to use it in my own data but it did not sum up the totals per contractor, and instead shows one total in one range.
each contractor line only shows a value of of one, but there are multiple rows for each contractor. i need it to sum each of the contractors value's and then bucket them into the ranges. do i just use a simple sum equation?