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.3K Product Ideas
 1.3K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 281 Workbench
 2 Cloud Amplifier
 4 Federated
 2.8K Transform
 83 SQL DataFlows
 541 Datasets
 2.2K Magic ETL
 3.2K Visualize
 2.3K Charting
 518 Beast Mode
 26 Variables
 555 Automate
 129 Apps
 408 APIs & Domo Developer
 18 Workflows
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 343 Distribute
 85 Domo Everywhere
 257 Scheduled Reports
 1 Software Integrations
 81 Manage
 80 Governance & Security
 2 Product Release Questions
 Community Forums
 41 Getting Started
 27 Community Member Introductions
 78 Community Announcements
 4.8K Archive