4 Replies Latest reply: Mar 20, 2012 6:59 AM by Meelis Karulin RSS

    Can i use aggr function here?

      Hello. I have a simple question:

       

      I have table in my load script that looks like this

       

      Trans.      Product      Price

      1              Product 0     xxx

      1              Product 1     xxx

      2              Product 0     xxx

      2              Product 1     xxx

      3              Product 1     xxx

      4              Product 2     xxx

       

       

       

      Lets say "Product 0" is shipping fee. I need to find the sum of eatch transaction that was made in internet and shipped to the client not collected from the store.

      Can i achieve this with aggr function somehow? There are plenty of examples of how to use aggr but it's still difficult to understand.