I'm only on 10.3, so can't open your workbook. but you should be able to group the regions and then use whatever measures you want. See example attached. Just group the regions/states the way you would group anything, Then use that as your geography measure.
grouped states.twbx 1.2 MB
1 of 1 people found this helpful
You may need to join your data to a crosswalk table that just has:
Then you would group the Territories in Tableau
and put the group on the detail shelf.
Please see the attached.
Worked perfectly, thanks
I went through this thread, and was wondering, when you joined the countries to the sales data, additional rows have been created. So how did you manage the total sales or total sales by region?
Region Sales = 680 (originally)
but since the addition of territory:
Region Sales Territory =1780
QLD&NT 100 Queensland
QLD&NT 100 Northern Territory
SA&NSW&VIC 500 South Australia
SA&NSW&VIC 500 New South Wales
SA&NSW&VIC 500 Victoria
TAS 20 Tasmania
WA 60 Western Australia