cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytics Cloud - %Subtotal in Hierarchies

deobald1
Explorer
0 Kudos

Hi Experts, 

i have an account-member which is calculated as a %subtotal and some ignored dimensions. Everything works fine with a flat presentation or when i show only the leaves of the hierarchy. 

As an example we can follow the value for "OTH - Others" (blue) which is 0.02:

deobald1_2-1713259137055.png

When i change the view to see a hierachy of a specific public dimension, there is the follwing problem:

Each parent shows 1 (=100%) as a total of the childs. 

deobald1_3-1713259450120.png

So it seems, that SAC is calculation the %Subtotal for all childs of a node. 

What i need is the same values from screenshot 1 for the lowest level of the Hierachy and the a correct aggregation up to the parents. 

deobald1_4-1713259628616.png

This should also apply to the other nodes:

deobald1_5-1713260045069.png

Can sombody help here?

Thanks in advance!

Swen 

View Entire Topic
N1kh1l
Active Contributor

@deobald1 

Subtotals% are calculated by each level and not rolled up so it will calculate ST% separately for parent nodes and child. 

What you need is kind of contribution % so you should calculate it explicitly by dividing the child value by the Grandtotal. Grand total you can get by Grandtotal formula in story and then just calculate contribution by [Measure]/GT

 

Hope this helps !!

Nikhil