Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is there away to add the ranking before the Pricing Groups in the following expression?
Example:
1 - Pricing group A
2 -Pricing group D
3 -Pricing group C
=If(Aggr(Rank(Sum({$<SQType={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU)), [Pricing Groups])<=3, [Pricing Groups], Null())
May be you can append rank before like this
= Rank(Field) & '-' & Your Current expression
Thanks for your response Shivesh, however it does not seem to work...
This is what i tried:
= Rank(Field) & '-' &If(Aggr(Rank(Sum({$<SQType={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU)), [Pricing Groups])<=3, [Pricing Groups], Null())
Hi
By Rank(Field) i meant to say, You have to put the expression or Column name in place of Field basis on which your Rank is calculated.
May be this expression or something - =Rank(Sum({$<SQType={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU))
Hi,
Unfortunately it did not do the trick...
I am struggling with it considering the length of the expression and am not sure what element should be the field.
Could the issue be that i already have an Rank() in my original expression?
Ok, what is the logic for these numbers? 1,2,3?
They are purely to list up the top 3 so not very important, but i still would have liked to see them there..
Can you try this?
RowNo() & '-' &Your expression
Unfortunately it did not do the trick:
Cool , I missed that it has to be done in dimension.
You can use below logic to append the rank
=aggr(rank(Dim),Dim)&'-'&Dim
Or share a sample file to work upon.