Total Column in a different column
Good Morning
I have a column let's say (look below) Is there a way to create another column with the total sum of that column? So it reads a new column that says total and it should be the same number? Thanks!
category category total
A 1 A 1 6
A 0 A 0 6
A 2 A 2 6
A 3 A 3 6
A 0 A 0 6
B 0 B 0 2
B 2 B 2 2
TOTAL 8
Best Answer
-
sounds like you're trying to do a category subtotal.
you can implement that with a windowed function
sum(sum(amount)) over (partition by category)
you need to have the feature switch enabled. talk to your csm.
If you've never worked with them before they can be super powerful but also have some pretty stringent caveats.
https://www.youtube.com/watch?v=eifSYZIcPzg&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=5&t=466s
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
It worked perfectly! Thanks!
0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 53 Domo Everywhere
- 2K Charting
- 999 Ideas Exchange
- 902 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部