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
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive