Filled Maps custom hierarchy combining more than one state
Hi,
I am trying to create filled maps for states , the problem is that sales data is in one case summarized by 3 states and for remaining rows it on the level of single state
like in example below
| State or States | Sales |
| Maine, New Hampshire, Vermont | 17492 |
| Alabama | 19511 |
| Arizona | 35282 |
| Arkansas | 11678 |
Is there a way to create new hierarchy for filled maps which will combine more than one state ?
for example instead of :
country -> State
should be:
country -> CombinedStates -> State
| State or States | Sales |
| Maine, New Hampshire, Vermont | 17492 |
| Alabama | 19511 |
| Arizona | 35282 |
| Arkansas | 11678 |
