Calculating ranks

[deepakqlikview_123]

Hi All,

I haveques as per below,
1 How to calculate rank for negative numbers

2How to calculate rankif there are both positive and negative numbers.

thanks,

Deepak

[Gysbert_Wassenaar]

Use the rank() function. Multiply by -1 if you want to rank from smallest to largest value so that the smallest value gets a rank of 1.

[jagan · Accepted solution]

Hi Deepak,

Use Rank() like below

For Example

Dimension: Employee

Measure: Rank(Sum(Sales))

Employee with highest sales receives Rank1, and so on.  Whether it is positive or negative the rank is calculated based on the numbers.

Regards,

Jagan.

[deepakqlikview_123]

Thanks both of you