Sometimes the name of the region is not enough, please provide addtional info to make the region unique.
In the case with US, the county name and the county 3 digit code is not unique, so the state code and the country code needs to be supplied:
Example For United States:
Administrative level 1, State, the code is the state abbreviation: =state_abbr & ',US'
Administrative level 2, Counties, the code is the three digit fips code.
To make the code unique, supply both county and state code:
=county_fips & ',' & state_abbr & ', US'
Check out my example app.
US Counties.qvf 9.0 MB