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 to any 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