How to do calculate complex formulas in SAP Analytics Cloud

Hi everyone,

we are trying to create a table like in the following screenshot with local calculations within SAP Analytics Cloud:

So far we could not succeed, we can calculate the %grandtotal using the Model Builder for the Key Figure Spend, but the rest of the calculations we canot do as in excel.

Any idea how to create this table in SAC?

Thanks a lot for your help in advance.

Regards
Torben