How to sum the data of alternate hierarchy?

Hello everyone,

I have one question about the function for sum data of alternate hierarchy.

I have Hierarchy which is like this:

And member A4 appears under both hierarchy 1 & 2.

When I use the function @SUMRANGE to sum the data or this hierarchy:

@SUMRANGE(****, @RELATIVE(Hierarchy,0);

I found that the data of A4 is a duplicate.

So I searched on Oracle Calculation lists and found the function called @MERGE (https://docs.oracle.com/en/database/other-databases/essbase/21/esscq/merge.html)

And I modified my calculation : @SUMRANGE(****, @MERGE(@RELATIVE("Hierarchy 1",0), @RELATIVE("Hierarchy 2",0)));

However, it gave me the same result as @SUMRANGE(****, @RELATIVE(Hierarchy,0);