Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a file containing the following info
OrderID
OderLineDescription
OrderLineAmount
I would need to create an additional column in the script that aggregates the sum of all OrderLineAmount per Order ID to get the TotalOrderAmount
TotalOrderAmount
Could you please advise on the syntax?
sum(aggr(OrderLineAmount, OrderID)) as TotalOrderAmount
Many thanks!