1 of 1 people found this helpful
Stick the data on 2 separate sheets in the same excel workbook
Connect to the excel file from tableau
you will be able to drag both sheets on to the data connection view where you can set relationships
You need a left join with you figures on the left and reference sheet on the right
once you have done this
if your country names have not been recognised as a geo field (World Logo next to Field name) then right click the dimension go to geographical role and select country
Now pull the country and measure required on to sheet and select Map on show me
anything else you need help with give me a shout or if you get stuck following the above instructions.
It is useful.
Please mark as helpful and if it has answered your question please mark the thread as answered.
If you have any further questions or unable to produce the visualisation you require please share some sample data or sample workbook and myself or another community member can assist