1 Reply Latest reply: Apr 17, 2014 5:02 AM by Manish Kachhia RSS

    Top N PERCENTAGE(%) performers/users.

    Ram Asokan

      Hi folks,

       

      How do you - get the results of N percentage users?

       

      I know there is a rank function but if am not mistaken you can only derive using exact figures from it, e.g. (if(rank(sum(SALES))<=10) but what I want to know is how can I do so but using percentage? e.g. finding Top 20% performers, Median 30%, BTM 50%?

       

      Please advise. Thanks in advance.

       

      Best Regards,

      R