Pivot Table Subtotal Control
rockchalk629
Member
If your column is doing a beast mode based on the individual line level in a pivot table the subtotal will follow that rule (i.e. if you are using max() in a beast mode).
It would be helpful to have a subtotal or total override if it's the case that you don't want subtotals to adhere to beastmode logic. i.e. you want the subtotal to be a sum of the max() number.
Tagged:
9
Comments
-
YES - this can be super frustrating. I've had to exclude columns from subtotaling because the beast mode aggregation isn't appropriate for the subtotal aggregation!
Broadway + Data1 -
Agreed! I'd also add a couple requests to your idea, specifically for Pivot Table cards:
- Option to disable subtotals for individual value fields, similar to how it works for fields in Mega Tables
- Option to disable subtotals for individual row/column fields. Currently subtotals are available for all rows or all columns, but cards can become very messy for when they have many row fields that each have their own subtotals.
4
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive