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

Zuko
Zuko Member
in Magic ETL

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


Tagged:

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    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:

    image.png


    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories