Data Range Grouping

[cheid1977]

I would like to take shipment weights and break them down into weight ranges (ex. 0 - 5, 5 -10, 10-20, etc).  I tried the Groups function, but I would have to update that everytime my data was refreshed with new data due to new shipment weights being added.  Is there a recommended formula that could be used that would allow the shipment weight to be grouped into these weight ranges i provided earlier and update as my data is refreshed? Thanks.

[v-ljerr-msft]

Hi @cheid1977,

Have you tried the solution provided above? Does it work in your scenario? If the solution works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here. 

Regards

[cheid1977]

Thanks for the recommendation. I have had a chance to test it out. As soon as I do I will let you know if it works. 

[Anonymous]

I would just add a calculated column "Weight Bucket".  There are a few ways to do this (eg, you could have a separate table that controls the buckets and lookup into it)  or whatever, that has the formula (something like)

  Bucket = SWITCH( TRUE(),
    [Weight] <= 5, "0-5",
    [Weight] <= 10, "5-10",
    ...
    [Weight] <= 100, "80-100",
    "Real Heavy"
  )