Skip to Content
Jan 21, 2021 at 09:20 PM

How to calculate the sum of the values of fields of member IDs of a hierachy?

77 Views Last edit Jan 21, 2021 at 09:32 PM 2 rev

Hello togehter,

I have created a hierarchy for a generic dimension and I show this information in a table. For one member ID i need to calculate the sum of several member Ids of this hierarchy for this dimension. Please see the next screenshot to understand my question. Right now this level of the herarchy (member ID) is empty as the value has to be calculated inside the SAC.

We are using a model and a story. Where and how we could do that? The values are actually inside a measure and not in the dimension.

In our Story the Aggregation type for calculation is not shown like shown in this screenshot:

See youtube video:

Thank you