5 Replies Latest reply: Jun 28, 2011 7:35 AM by Miguel Angel Baeyens de Arce RSS

    How to calculate who the top customer is

      Hi

      I would like to add column in my table to display what customer is the biggest buyer for a product. And in the next column I would like to show how many that customer bought from that product.

      Pseudo code for customer name: Print Name where max(sum(InvQty))

      Pseudo code for qty: Print qty where max(sum(InvQty))

       

      Any ideas?