7 Replies Latest reply on Aug 7, 2018 5:10 AM by Jim Dehner

    Geographic Role: Create From

    Brad Slaughter

      I am attempting to take a list of counties and states and aggregate them into markets.  To do that I am using a county field and state field (so I do not lose duplicate counties that are in multiple states).  My market names are already in my data.  I want to take my market field and create a geographic role from both county AND state.  Is there a way to do this?  I tried making a hierarchy and a combined field and neither worked.  I can highlight the counties I want and manually create a group but that seems like re-work in my case.

       

      I cannot post my workbook but I was able to post the market information that I have.