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:

      Ex.

      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?

       

      Thanks!