Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
can you use this in anyway.
rank
( pick(match(d,'M1','M2','M3','M4')
,sum(M1)
,sum(M2)
,sum(M3)
,sum(M4)
),3,0)
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)
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)
Great, thank you.