Hi All,
I have a table with Country, products, sales% of Products and Rank of each product based on sales and country.
| Country |
Product |
Sales % |
Rank |
| XX |
ABC |
0.60% |
34 |
| YY |
EFG |
0.40% |
49 |
| ZZ |
HIJ |
0.30% |
54 |
I want to display the Rank of particular Product "EFG" in a KPI. I am using the same formula in KPI as used in table. But I always get Rank value as 1 in KPI (I think it is comparing against the same product hence 1). I want to display the actual Rank which is 49 in KPI as in the table.
I am calculating the Sales% as :
vSales = num(SUM({$<[MonthYear] = {'$(vCurrentMonth)'}, Product >} $(=[Sales]))
/
SUM(TOTAL {$<[MonthYear] = {'$(vCurrentMonth)'}, Product >} $(=[Sales])),'0,0000%')
I am calculating the Rank as :
RANK = Aggr(Rank($(vSales),4,1),Country,Product)
Any suggestions on this.
Thanks in Advance
