1 Reply Latest reply on Dec 8, 2016 4:38 AM by Łukasz Majewski

    Filled Maps custom hierarchy combining more than one state

    Bartek C

      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 StatesSales
      Maine, New Hampshire, Vermont17492
      Alabama19511
      Arizona35282
      Arkansas11678

       

       

      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

       

       

       

      Sales by States 01.png

                        

      State or StatesSales
      Maine, New Hampshire, Vermont17492
      Alabama19511
      Arizona35282
      Arkansas11678