Remove shared members from XRANGE
Summary
@REMOVE in @XRANGE not working as expectedContent
Hi experts,
we have the following custom calculation which counts the members of Period dimension in a given range:
@XRANGE(
@CURRMBR(ContractYear)->@CURRMBR(Period),Year->Period)
The second part of the XRANGE function is always a fix value based on variables. The issue comes because there is a new set of shared members inside the Period dimension (new hierarchy in blue):
Period
|_ Year Total
|_ Jan
|_ Feb
....
|_ Dec
|_ Year Total_Quarter
|_Q1
|_ Jan (Shared)
|_ Feb (Shared)
....
|_Q4
....
|_ Dec (Shared)
Now, the custom calculation adds 12 members on the XRANGE function everytime the year changes: