Your workbook is connected to a live file, so I cannot see the data, you would need to take an extract first, but I think I understand your question and will hopefully be able to answer it with superstore data:

Superstore has a text field "Region" (central, east, south, and west) the way the data is structured, every record has both state and region fields so we can set a geographic role for region, based off of state:

now we have the regions calculated based on the states that make them up and can throw profit on color for a filled map, colored by region rather than state:

hope this helps! if not please take an extract of your data and re-post the packaged workbook, and I will take a look