Ranking Including All The Dimensions and Expression

[#1]

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.

[jagan · Accepted solution]

Hi,

Use TOTAL in the Rank().

=rank(TOTAL sum({< Customer = {"=rank(sum([SalesValue]), Customer) <=$(vRankNo)"} >} [SalesValue])  )

Hope this helps you.

Regards,

Jagan.

[#3]

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])  )