How to calculate against row values, instead of a summation, when using a beast mode within a pivot

I'm currently using a simple beast mode within a pivot the table. The beast mode calculates the percentage change in the values from two columns.
The issue is that, for subtotal and total, the beast mode is summing up all the percentage change values above it, therefore returning inaccurate values.
Is there a way to calculate, for subtotals and total, to calculate laterally to return the correct percentage change?
Thanks!
Best Answer
-
@muahmmad_zaidi You can set up your % Change beast mode to calculate based off of the sums of your two fields like this:
(sum(`Field1`) - sum(`Field2`))/sum(`Field2`)
1
Answers
-
@muahmmad_zaidi You can set up your % Change beast mode to calculate based off of the sums of your two fields like this:
(sum(`Field1`) - sum(`Field2`))/sum(`Field2`)
1 -
The totals and subtotals tend to follow the aggregation type used on the field itself. If you switch to average, your subtotal should show the average. Additionally, you may want to look at using the additional aggregation types available on the field that allow you to show the percent of the row or column for that field.
**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.0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 257 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 501 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 375 Beast Mode
- 20 Variables
- 485 Automate
- 103 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive