Auto "Grouping"

[abeiswinger]

Every month we have inspections with ratings (anywhere from 0 - 100%).  I can create Groups so that anything that falls between 0-9% is in one group, 10-19% is another, etc. etc.... instead of showing me lines for every single rating in that range.  

But let's say this month I have 5 inspections/5 ratings: (example) 13%, 22%, 17%, 50%, 100%

Next month, if I have a rating that is 11%, I want it to be group with the 13 & 17 %'s... how can I make a formula so that it automatically includes new data to my existing groups?

Thanks in advance.

[v-chuncz-msft · Accepted solution]

@abeiswinger,

You just need to use nested IF Function or SWITCH Function to add a calculated column.