Pivot Table Grand Total

When I add the "Total Row" to a pivot table, it does not always show the "Grand Total". If the column has an aggregation applied, then the Grand Total shows the aggregation (Average, Maximum, Minimum, etc.) instead of a Total.
Is there a way to show the actual "Grand Total" (aka the sum of the values) rather than the aggregation?
Best Answer
-
@JasonKerr Try using a FIXED function in your beast mode and put your row and column fields into the FIXED BY clause.
Here is an article on FIXED functions:
0
Answers
-
@JasonKerr Try using a FIXED function in your beast mode and put your row and column fields into the FIXED BY clause.
Here is an article on FIXED functions:
0 -
@MichelleH This wouldn't work in a pivot table, right? Adding any new "value" fields will have them show up in each segmentation of the table. I am only looking to add one row at the bottom of the table with a total of the values in the columns.
0 -
@JasonKerr I mean to use the FIXED beast mode in place of the existing value field. By using the FIXED aggregation, you are dictating how you want the grand total row to calculate instead of the default aggregation.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 798 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive