Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings All,
Could you please tell me how to rank one calculated field where other calculated fields are there.
I know this explanation is might be Fussy.
Please find attached of the qvw file. I hope by seeing this model you all will able to figure out my problem.
Waiting for the response.
Thanks in Advance.
Pihu.
Hi,
Use TOTAL in the Rank().
=rank(TOTAL sum({< Customer = {"=rank(sum([SalesValue]), Customer) <=$(vRankNo)"} >} [SalesValue]) )
Hope this helps you.
Regards,
Jagan.
Hi,
Use TOTAL in the Rank().
=rank(TOTAL sum({< Customer = {"=rank(sum([SalesValue]), Customer) <=$(vRankNo)"} >} [SalesValue]) )
Hope this helps you.
Regards,
Jagan.
Thanks Jagan..!!
I found where I was wrong.
NB: If we have more than one expression and we want to use rank then we should rank only one specific field.
It also works for me.
(sum({<customer_code= {"=rank(sum([logistics_fee]), [customer_code]) <=$(vRankNo)"} >} [logistics_fee]) )