on 10-26-2010 3:47 PM
Hi,
I've successfully (more or less) created a rank of this kind
<expression>Rank([0CERTIFIC].CurrentMember, [0CERTIFIC].CurrentMember.Level.Members)</expression>
Now I'd like to specify the order of the rank (desc or asc by [0CERTIFIC].CurrentMember.Name).
Could you please help me?
Hi,
You can do a rank on a given measure like this:
<expression>Rank([0CERTIFIC].CurrentMember, ORDER( [0CERTIFIC].CurrentMember.Level.Members, [Measures][MyMeasure], BDESC) )</expression>
Didier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So no way of specifying the ordering on the key of the dimension member (alphabetically ASC or DESC)?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.