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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 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
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 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