6 Replies Latest reply: Oct 2, 2011 1:01 AM by Anand Chouhan RSS

    Can I show Top 25 salesman with detached display using set analysis?



      I have countries and sales amounts (per sales representative) and would like to show a table for top 25 salesman in each specific country and then take averages of it. I am using straight table.




           Salesrep Name



           =IF(AGGR(RANK (Total(sum(sales))),[Salesrep Name])<=25,sum(sales ))


      However, my expression is selection dependant. I would like to detach it permanently so that we will always see top 25 sales rep in each country.


      To be able to do that; I was trying to change my expression into:


           =IF(AGGR(RANK (Total(sum({1<REGION={Singapore}>}sales))),[Salesrep Name])<=25,sum({1<REGION={Singapore}>}sales))


      However, it is still selection dependant. (if I choose other countries from listbox, this table does not bring any figures). Would you have any suggestions?


      Thanks in advance.

      Best regards,