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
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive