1 Reply Latest reply: Jan 5, 2012 6:30 PM by Stefan Wühl RSS

    Average sales price per customer

      Hi,

       

      I have an issue that to me should be straight forward but I can't work out how to do it.

       

      I have a price list in one table and sales orders per customer in another one. What I want to get the average size of the sales orders per customer and the total sales per customer.

       

      ModelPrice
      X100
      Y200
      Z350
      Customer
      ModelQuantity
      AX10
      BX5
      CY3
      AY8
      AZ7
      CZ4
      BZ12
      BY3

      Any help would be appreciated.

       

      Cheers,

      Peter

        • Average sales price per customer
          Stefan Wühl

          Peter,

           

          Hope I got correctly what you want:

           

          You could create a straight table chart with dimension Customer, then two expressions:

           

          = sum(Quantity*Price)

           

          for the total sales

           

          = avg(Quantity)

           

          for the average size of sales (or do you want avg(Quantity*Price) ?).

           

          Hope this helps,

          Stefan