Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have UL Count and Target UL Count as dimension , UL Count % as UL Count /Target UL Count and Rank as the rank function.
How do i create a text box where i pull UL count (eg. 70) when Rank = 1?
Thanks!
If so, My expression should work. any way can you try this?
FirstSortedValue([UL Count],-Aggr((Sum([UL Count])/Sum([Total UL Count])), [UL Count]))
OR
FirstSortedValue([UL Count],Aggr((Sum([UL Count])/Sum([Total UL Count])), [UL Count]))
May be this?
If(Rank(Sum([UL Count])/Sum([Total UL Count]))=1, [UL Count])
try this
text box
=[UI Count]&' '& Rank
May be This!!
Only({<Rank={1}>}[UI Count])
It returns blank though.
Do i have to aggr "Rank(Sum([UL Count])/Sum([Total UL Count]))"?
I need to return only 1st rank though
How you got [UL Count %] ??
As Rank is an expression with Rank(total "UL Count"/"Target UL Count"), i tried this instead:
Only({<Rank(total "UL Count"/"Target UL Count")={1}>}[UI Count])
but i got error in set modifier expression
With this expression - UL Count /Target UL Count
I thought you need to do in separate way..first you need to calculate rank then you can try with above expression.it will works.