1 Reply Latest reply on Jun 15, 2017 2:15 PM by Hari Ankem

    Editing Locations - when data contains full state names and acronyms

    Rebecca Saracini

      Question 1:

      I have data that contains full state names and acronyms.

      In 'Edit Locations' - both are the set to the same matching location:


      TX = Texas

      Texas = Texas


      However, data on my map is still separated between TX and Texas.

      EX. Pie chart on map for sum of sales in Houston - shows separate pieces for Houston TX as $1M and Houston Texas as $2M


      I need the data to combine as one state.


      Question 2:

      When I 'Edit Locations'  - do these edits remain valid if I create a new worksheet?