The radio button options contain reoccurring words (e.g. North, South). I'd like to report and group with the option's remain words (e.g. Dade, Broward).
Perhaps it'll require a calculated field and a calculated column. I've tired many variations similar to: IF(CONTAINS(Region,“North Broward”),"Broward”),IF(CONTAINS (Region,“South Broward”),"Broward”),IF(CONTAINS(Region,“North Dade”,"Dade”),
IF(CONTAINS(Region,“South Dade,"Dade”))
It's no longer fun and I'm nearly out of time, Have Mercy
