You need to work on your data structure,
1. Transpose your measures from columns to rows. You need to pivot your data. You may get several links for pivoting. Post pivot perform below steps
2. Extract Territory information from the pivot field names. You've to remove TEMP word from "BEIJING TEMP".
3. Rename the pivot field value as "TEMPERATURE"
I hope in this way you can easily get the desired output and you don't have to join with any other table.
Give a try and let us know if this work.
Because it's company file I cannot post it but I have 100+ lines to deal with not just this simple table. Therefore, just changing the title is impossible for me and the solution for me can only be doing transposed in tableau itself which calculation etc might helps. However, just need to figure out how to do it.
Find the steps below,
Step 1: Connect your source and pivot on your fields like this
Step 2: Delete the invalid fields
Step 3. Rename the Pivot field names and values. Once done your data is ready
Step 4: Now remove the TEMP word using REPLACE(). Go to worksheet and create a calculated field using below logic
Step 5: Now, drag the fields in canvas
If you still have to join with other data source then you may do like this
Let us know if this help. Sample workbook attached for your reference.
Sample_v10.2.twbx 13.7 KB
Thanks for that, it helps a lot