How to create a column which SUMS based on the grouping of another column

Mattwjones

Hello,

I am trying to write an ETL which sums a value based on the grouping in another column (invoice number) which yields a column with the total quantity for each invoice.

i have attached a simple table as an illustration of what i am looking to achieve.

I do not want to write a formula where i have to continually update the invoice numbers as i am looking to automate all reporting.

Any help is greatly appreciated.

2022-12-05_11-20-48.png

MarkSnodgrass

You can use the group by tile to sum your quantity by invoice number and then join it back to your original dataset to get the total next to the individual items by joining back on invoice number. Your ETL would look something like this: