Is there a better way to play with Table Totals/subtotals?


Hi domo community, question.
I'm having hard time getting my totals to look the way I want to look on a table, the perfect collapsed view would be
If add and extra column and hide totals/subtotals and suppress ingle items in subtotals looks ok on expanded view (Image 1.1), But if I collapse it looks like image 1.2
Let me know your thoughts, I always have problems when I try to mirror financial reports (I hope I was clear enough :/ )
Lilia
Best Answer
-
There are limitations on how Pivot Tables are shown there is an open Idea you can support:
For your specific purpose you might be able to get it to look the way you want by:
- Leave the Suppress Single Line items option unchecked.
- While in Analyzer, hover over the first entry in the Currency Column, and you'll see a plus/minus sign appear on the right side (only visible by hovering) this will allow you to configure all the data after it to be collapsed by default when looking at the table, while still allowing your users to expand it as needed when they want to go into more detail on the underlying data.
Let me know if that helps.
0
Answers
-
There are limitations on how Pivot Tables are shown there is an open Idea you can support:
For your specific purpose you might be able to get it to look the way you want by:
- Leave the Suppress Single Line items option unchecked.
- While in Analyzer, hover over the first entry in the Currency Column, and you'll see a plus/minus sign appear on the right side (only visible by hovering) this will allow you to configure all the data after it to be collapsed by default when looking at the table, while still allowing your users to expand it as needed when they want to go into more detail on the underlying data.
Let me know if that helps.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 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