sum values differently based on different hierarchy

Hi all, 

I would like values to be shown differently based on hierarchy. In this case (see picture below), when predicted sales are summed up on a country level, i would like to take it from the country table whereas if it is in the shop level, it should take from shop level table. 

Any help is appreciated thanks in advance 😄