If your Sub-Regions are divided by State, you shouldn't need to have lat/long, as States have their own inherent, recognized lat/longs.
You should just be able to add the Sub-Region column to your data and color/total by this dimension.
Our Sub-Regions dimension doesn't have State, it goes from Sub-Regions to Sites. A Site could be one or more cities, for instance we have a Site OPS which is Orange County, Palo Veres and San Diege in California.
So I was trying to have the GeoCode show the breakout by State which is why I was initially creating the file. To map the States to the applicable Sub-Region so someone can report to the Sub-Region level and show the States on the map.