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))