This content has been marked as final. Show 4 replies
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.