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.