How to Rank Top X Measures

[#1]

Hi,

I am trying to rank top 2 measures (see attched). Unfortunately, I am not allowed to crosstable the data and convert the measures into dimension, and so I am not sure how to apply "normal" aggr(if(rank(sum(VALUE))...

Any help will be appreciated.

[Tammy_Milsom]

can you use this in anyway.

rank

( pick(match(d,'M1','M2','M3','M4')

,sum(M1)

,sum(M2)

,sum(M3)

,sum(M4)

),3,0)

[#3]

Hi tmm,

this is helpful, but how do I display top 2 measure? I cannot seem to get the expression below to work.

=aggr(if(rank(pick(match(d,'M1','M2','M3','M4')

,sum(M1)

,sum(M2)

,sum(M3)

,sum(M4)

),3,0)<=2,d),d)

[swuehl · Accepted solution]

Maybe like attached, using

=aggr(if(rank(pick(match(d,'M1','M2','M3','M4')

,sum(M1)

,sum(M2)

,sum(M3)

,sum(M4)

),3,0)<=2,d),Dim_01,d)

[#5]

Great, thank you.