As @saran7de wrote, CrossTable() is the way to go, but you don't need all the preparation steps, you can do the crosstable straight of the excel file. Just make sure that you load your qualifier fields first, notice that I moved Source (the last column in excel) up front before the fields that you want to pivot.
CrossTable(Ethnicity,[Percent Value],4) //4=four qualifying fields
Source, //Qualifying field (1)
Function, //Qualifying field (2)
Country, //Qualifying field (3)
Area, //Qualifying field (4)
FROM Excel.xlsx (ooxml embedded labels);
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
You have two very good posts here, we would appreciate it greatly if you would complete the thread by using the Accept as Solution button on the post(s) that helped you with your solution. If you did something different, you can post what you did and then mark that, and if you still have questions, leave an update comment.
Here is a Design Blog post related to the feature the guys discussed too that may provide further clarification on the use of the feature they discussed.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.