7 Replies Latest reply: Jul 14, 2016 5:05 AM by Catalin D RSS

    Top x % with rank

    Catalin D

      Hi,

       

      I have a request that sounds like this.. We need a table that shows:

      -top 20% (out of the total number of rank A clients) rank A clients sorted by total sales.

      -top 30% (out of the total number of rank B clients) rank B clients sorted by total sales.

      -top 50% (out of the total number of rank C clients) rank C clients sorted by total sales.

       

      Any thoughts on how I should approach this?

       

      Thanks!