Hi - I seem to be struggling with something very simple. Normally I will do in SQL but QVD not sure about this:
Want a GroupBy code and then Sum(price * qty) for each distinct. The result I am getting thus far is giving me all the codes and different sums for each (which is correct). I want to end with a single code and calculated value for each.
LOAD code, price, qty FROM [lib://CellTotalCost.QVD]