Couldn't get there, but maybe can give an idea.
Or at least, can bump this question back up.
I was only able to get some of the cities to show by using a dual axis.
One map has Country and State on Details, the other has Country and City on Details.
Could not get Germany or Vancouver to show.
Please see the attached in the Forum Thread.
258116map.twbx 42.8 KB
Thank you, I really appreciate your thoughts around this! I'll see if I can leverage this approach in my full data set.
Thanks for looping me in...I'm going to try to punt this over to Dan Cory though to share his mapping wisdom and see if he has a solution to suggest.
I didn't want to let the question drop, but I'm out of the office with limited connectivity right now and can't dig into the problem right now.
With dual axes, you can do two levels of geography, but there's no way to do three.