Hello,
I am trying to write an accumulation script but I am unable to succeed.
May you assist me, please?
SalesAggFinal:
LOAD
YearMonth,
"Group",
Quantity,
TotalPriceBeforVat,
TotalPriceBeforVat/Quantity as unitprice
FROM [lib://DB/SalesAggFinal.qvd]
(qvd);
SalesAggAcc:
LOAD "Group",
YearMonth,
TotalPriceBeforVat, RangeSum(peek('Cumulative') , TotalPriceBeforVat) AS TotalPriceBeforVatCumulative
Resident SalesAggFinal;
exit script
Before:
After:
What do I need to do?\