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: