Subtotals in PivotTables
I am currently working on bringing some pivot tables to my customer however they find these subtotals duplicates not really esthetics and confusing. Is there a way to get rid of them? I tried "Hite Subtotals" option but with no effect.
Comments
-
@m_malecka I've run into that issue as well and have not found a way around it. I'd suggest contacting Domo Support about the "Hide Subtotals" option not working and posting to the Ideas Exchange to about enhancements to the subtotal functionality.
1 -
The thing there is that you have 2 rows, Level and Spend, and I'd guess each level is tied to only a single Spend based from your screenshot, if that is not always the case then you want to keep it the way it is, as the numbers will not always be "duplicated". As a workaround, you could display only one or a single one that is the concatenation of both values, not the prettiest solution but something that you can apply right away. I agree with @MichelleH and having a feature that would allow us to indicate the number of levels at which we want subtotals calculated would be awesome.
1 -
Thank you both! Yeah - displaying a single category is what I thought as well but my customer wants to see both.. I´ll contact with Domo support and hopefully they can provide a solution into this.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive