I don't understand it doesn't calculate margin/revenue properly.
Change the summary setting in the blueprint to be Formula for Margin %. Currently, it is summing the data and you are looking at an aggregated level (Americas).
Yes, You're right and it works. Many thanks!!!
Quick question : Margin has a formula, too but I don't need to change the summary setting to be Formula for Margin. It works properly with Sum in the Summary setting. Why?0
Because Margin % is division and needs to evaluate the numbers at every level instead of at the lowest level and then summing up the hierarchy.