Survey Results Analysis

My Company has run an employee opinion survey (keep in mind over 100k surveyed, 31 questions in the agree/strongly agree/strongly disagree etc. format) 

I've been given a report that sumarizes the information into a hierarchy, informing me how many valid responses were collected for each question in each level of the hierarchy and the % of those valid results per answer option. 

The problem is that there are over 5000 organizational units (see simplified example below), but i can't create a simple hierarchy on power bi because my results are already summed up in the next higher org. level.

Additionally, the levels below an org unit wont necessarily add up to what the level already shows: Sweden, Greece, Germany, France and Italy dont add up to Europe because there are people counted only at the europe level; the same loghic applies to Europe and Africa not adding up to the Europe & Africa pre-sum. 

The data set is too big for manual changes, what can I do to make this process easier?