Sum of Specific Expense Type

I have 5 different Expense Category and want to bring the sum of a specific expense category. What should be the formula
Best Answer
-
Try
sum(case when
Parent Expense Category Name
= 'P-CARD' THENTransaction Amount
END)When working with pivot tables, I find it easier to re-structure the underlying dataset to get the desired pivot format. Beast modes can be a hit-or miss when the goal is to display a customized calculation in a pivot table.
0
Answers
-
Depending on what you are actually displaying, you could simply drag your expense category into the filters and filter to that specific category.
If you need to still show the other categories, you can create a beast mode that only sums that category like this:
SUM(CASE WHEN category = 'mycategory' THEN valuefield END)
**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 -
CASE WHEN
Parent Expense Category Name
= 'P-CARD' THEN SUM(Transaction Amount
) END this formula gives me the sum at a total level. IN the pivot table I have the business segment and the function for which the individual values do not show up.So basically I want the expense category numbers total by Business function level too in the pivot.
0 -
Try
sum(case when
Parent Expense Category Name
= 'P-CARD' THENTransaction Amount
END)When working with pivot tables, I find it easier to re-structure the underlying dataset to get the desired pivot format. Beast modes can be a hit-or miss when the goal is to display a customized calculation in a pivot table.
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive