1 of 1 people found this helpful
Would creating a calculated field for the bucket category work for you? Something like...
IF [Total] <= 5000 THEN "< 5k" ELSEIF [Total] <= 24000 THEN "'5k-24k" ELSEIF [Total] <= 40000 THEN "'24k-40k" ELSE "40k+" END
I'm not certain how you've got the CPT & DX, Exceptions and Other columns setup so you may need a calculated field for each of those to get your Total in above.
Hope that helps.
Thanks Gordon, I made the groups and I get the correct banding I when I include the names. When I remove the names (to get totals by band) I get overlap.
Any additonal idea?
Moises. What do you mean by get overlap? Can you post a screenshot?
What if you put the name on the "level of detail" shelf?