5 Replies Latest reply: Jun 6, 2011 4:36 AM by Ali Hijazi RSS

    rank salesmen

    Ali Hijazi

      Hello

      I have a chart in which I'm displaying names of salesmen and next to each one I'm displaying the count of invoices related to each salesman

      what I want now is to display the rank of each salesman based on the number of invoices

      I have the dimension set to the salesman code and in the third column the expression is rank(count(invoice))

      what I'm getting in the rank column is numbers 1,2,4,... but these numbers are being repeated for other salesmen even if the number of invoices is different

       

      Please help