I would like to understand the logic of ordering Load-Statements.
The following script doesn't work as intended. I'm trying to make a "Rangesum" with the Peek()-function. It looks good at the first glance, but if I try to make a separate Load-statement to order the Sales, an error occurs.
//*3.* Finally, I'm trying to safe the table temporarilly and order by Customer_Aggr
Resident Operations Order By Customer_Aggr;
//*2.* Than I load the data and make the rangesum-operation with peek()
Customer_Sales + Peek(Customer_Sales,-1) AS Customer_Aggr;