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?

    Kadir Okan Piroglu

      Hi,

       

      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.

       

      Dimensions:

           Region

           Salesrep Name

       

      Expression:

           =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,

      piroglu1907