R
roger.camargo
Hello, I'm using this MDX expression to get a Calculated member for
sales rank:
RANK
(
( [Country].CurrentMember ),
ORDER(
[Country].CurrentMember.Siblings,
[Measures].[Sales],
BDESC
)
)
This works as expected, but this includes the TOTAL and assigns a rank
of 1
Argentina 1
Bolivia 2
Brasil 4
Peru 3
Grand Total 1
Another thing that happens is that if I filter a country for example
Argentina the table results like this:
Bolivia 2
Brasil 4
Peru 3
Grand Total 1
Now what do I want is to change the rank according to the visible
members of the Country dimension and if its posible hide the rank for
the Totals, (if argentina is filtered) it should be like this
Bolivia 1
Brasil 3
Peru 2
Grand Total
And if its not
Argentina 1
Bolivia 2
Brasil 4
Peru 3
Grand Total
I'd appreciate any hints on this, and maybe point me into a better
group to post this question, maybe someone know this easily.
Thanks in advence
sales rank:
RANK
(
( [Country].CurrentMember ),
ORDER(
[Country].CurrentMember.Siblings,
[Measures].[Sales],
BDESC
)
)
This works as expected, but this includes the TOTAL and assigns a rank
of 1
Argentina 1
Bolivia 2
Brasil 4
Peru 3
Grand Total 1
Another thing that happens is that if I filter a country for example
Argentina the table results like this:
Bolivia 2
Brasil 4
Peru 3
Grand Total 1
Now what do I want is to change the rank according to the visible
members of the Country dimension and if its posible hide the rank for
the Totals, (if argentina is filtered) it should be like this
Bolivia 1
Brasil 3
Peru 2
Grand Total
And if its not
Argentina 1
Bolivia 2
Brasil 4
Peru 3
Grand Total
I'd appreciate any hints on this, and maybe point me into a better
group to post this question, maybe someone know this easily.
Thanks in advence