Domo beastmode and pivot question
I'm trying to automate a file to run calculation in DOMO on a card.
In the attached I added a sample data and a pivot table to show what I'm trying to get to.
I was able to get the pivot completed in DOMO, but the additional column Collection Total, I cannot figure out how to create a beast mode for this, I'm trying case statements but I am not going very far.
The pivot is summarized by Job org and Class, while the additional column needs to add the totals of classes for a job org and subtract by the 8000 class.
Any help will be much appreciated.
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board