How can I extract the value of the upper hierarchy using calculated dimension

[sapuser0001]

I have a public dimension (e.g. Public_Retailer) in my data model, and loaded it into my dashboard.

The structure is like [market -> retailer]

I can definitely access the lowest level of this hierarchy in a calculated dimension by using the formula:

[d/"Sales":Public_Retailer]

But what I want to get is actually just the [market] part of the hierarchy. The formula used above is just capable of returnung the [retailer] as the output.

How can I extract the [market] if it is possible at all?

Thanks.

[N1kh1l]

sap.user0001

I don't think you can directly refer to the parent node value of the dimension member in calculated dimension. As a workaround you can create an attribute in the dimension and maintain the same values as parent in it. This attribute will be accessible in the calculated dimension editor. see below.

ROLLUP is an attribute with same value as parents.

Please upvote/accept if this helps.

Nikhil