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())
Does the attached help?
yes, it helped.
This expression will give you desired results.
=if(Aggr(Rank(Sum({$<[Quote Type]={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU)), [Pricing Groups])<=3,
Aggr(Rank(Sum({$<[Quote Type]={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU)), [Pricing Groups]))
&
'-'
&
If(Aggr(Rank(Sum({$<[Quote Type]={"DQ"}, [Week Num]={"$(=week(today()))"}>} TEU)), [Pricing Groups])<=3, [Pricing Groups], Null())
We're almost there Shiveshsingh!
Can we get the order right? 😬
Can you try putting sorting into Auto?
Thank you for your help on this @shiveshsingh that did the trick, however to make it perfect, i would like to remove the first " - ". Any suggestions?
I have just tried to have a go at it but couldn't work it out shiveshsingh sorry.
Attached is the sample file.
No luck bro, busy in some other task.
Ok thanks anyway for your help man, much appreciated.
If anyone figures it out, please let me know.