Hierarchy load present values in %

[DanVik3]

Hi all!

I have an parent/child table where i have used the hierarchy() function. I get the data as I wish to see it but i want to present it in an pivot table. The problem is that the values I have are in percent so I cant add them together with sum or use avg. I need to retrieve the precalculated values for each total.

How can that be done?

This is the data

I wish to have retrieve 11.3% as the total, 10.9 % as total for "Core" and so on. I tried dimensinality() but didnt get it to work when I suppress zero values.

Thanks in advance!