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.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 970 Connectors
- 259 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 502 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 379 Beast Mode
- 21 Variables
- 487 Automate
- 104 Apps
- 379 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 319 Distribute
- 67 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive