How to create a column which SUMS based on the grouping of another column
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.
Tagged:
0
Answers
-
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:
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 180 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive