Omitting rows in pivot table
Options

jakebutterfield
Member
Any way I can omit this section in a pivot table but keep the 2021 Total?
Tagged:
0
Best Answer
-
You can't truly omit those rows and still show the total, but you can click the minus sign next to 2021 which will collapse those rows keep the detail from showing. If you do this in analyzer, it will save as the default setting for the viewer of the card.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.3
Answers
-
You can't truly omit those rows and still show the total, but you can click the minus sign next to 2021 which will collapse those rows keep the detail from showing. If you do this in analyzer, it will save as the default setting for the viewer of the card.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.3 -
One of the most frustrating features of DOMO. Other BI systems I use auto compress rows like this.
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive