5 Replies Latest reply: Jul 19, 2018 4:41 AM by Prashanth Reddy RSS

    How to calculate total quantity by City/Customer

    Prashanth Reddy

      Hi Experts,

       

      I have one data set with products and their socket # and quantity.


      Sample Data: File attached

      In above example Total Sockets can be achieved by simple multiplication but my requirement is to calculate total sockets quantity by city and also by customer.

       

      Note: We can't do sum(sockets) * sum(quantities) as Socket # is specific to product id and can be same for other orders and only quantities can be summed for the respective product. Calculation should be like.. mentioned below (socket#  * sum(qty))

       

      Please help me in getting below outputs..?

      Thanks,

      Prashanth Reddy D.