I'm trying to display 1 total of sales per territory. Any help or suggestions would be greatly appreciated. Territories are assigned by zip code and I have sales at the zip code level. I'm simply looking to have a clean map showing 1 sales total per Territory.
Thanks.
Hey Kelly,
Unfortunately, you'll have to take County, State, and Zip Code out to get a total for the entire Region.
What I would do is create another view with these variables, and then make a Dual Axis map with the regions as you have them. On the Regions sheet, add the label.
Find example attached. You may have to tinker a little since I can't make a filed map with City or Zip with Superstore data, but you should be able to figure it out tinkering with that granularity.
Good luck!
Hi Kelly,
This is a new functionality of Tableau 10 called "custom territory", see here:
Have also a look at this blog post I wrote, which is going to give you the option to swap between each territory overall sales and the detailed zip code sales.
https://interworks.co.uk/blog/playing-maps-tableau-making-mapping-really-interactive/
Hope this helps,