Hi,
I want to rank duplicate values with the same rank. Please find the data and expression below.
| Region | % to PY | Rank |
| Region 1 | 107% | 1 |
| Region 2 | 104% | 2 |
| Region 3 | 103% | 3 |
| Region 4 | 101% | 4 |
| Region 5 | 102% | 5 |
| Region 6 | 100% | 6 |
| Region 7 | 100% | 6 |
| Region 8 | 100% | 6 |
| Region 9 | 99% | 7 |
| Region 10 | 99% | 7 |
| Region 11 | 98% | 8 |
| Region 12 | 97% | 9 |
Expression:
% to PY : Sum({<[Region Name]=>} [Sales Amount])/sum({<[Region Name]=>} [Prior Year Sales Amount])
Rank: Only({<[Region Name]={"Region 6"}>} Aggr(Rank(Sum({<[Region Name]=>} [Sales Amount])/sum({<[Region Name]=>} [Prior Year Sales Amount])), [Region Name]))
However with above Rank expression i am getting Rank as 7 for Region_7. But i want to get the rank as 6 for Region_7. Please help me. @
