Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So... I´d like to tie a ranking using a second expression.... for example:
If I had a dimension like SalesPerson and a expression like Rank(sum(sales),0,1) I will have some Salesperson with the same ranking position ... so .. if it happens I´d like to use another expression to tie that using something like Rank(sum(sales) , Count(Distinct OrderNo))
| Sales Person | sum(sales) | count(distinct OrderNo) | Ranking Actual Rank(sum(sales),0,1) | Desired Ranking Rank(????) |
| Rob Carsson | 123,200 | 120 | 1 | 1 |
| Joan Callins | 90,000 | 290 | 2 | 2 |
| Frank Roll | 90,000 | 134 | 2 | 3 |
| Helen Brolin | 50,000 | 239 | 4 | 4 |
Someone has a tip to do it ?
Thanks
rank( sum(Sales) + (count(distinct OrderNo)/1000), 0, 1)
rank( sum(Sales) + (count(distinct OrderNo)/1000), 0, 1)
Great! ... Thank You