Pivot Table - More control over subtotal rows
It would be a useful enhancement if you could select which rows showed subtotals in a pivot table. Right now, it is all or nothing. This can make for a busy, and not very helpful look, if there are several fields in the rows section. Would be nice if you could select if you just want to show subtotals for the first row and not the others, for example. In the screenshot below, for example, it would be nice to show just the subtotal for the highlighted section and not show the other subtotals.
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.
Comments
-
This is a pain point for us here at GE HealthCare as well. It would be great if this enhancement request can get some traction 😊
7 -
Completely agree! I have users downloading data from DOMO in order to pivot out in Excel, since the DOMO pivot card is unusable when only able to subtotal every row on a DOMO pivot card.
3 -
#LetsGo DOMO Team…..help out some frustrated users. Thanks!!
4 -
We have an option in pivot tables that may work for what you need. It is called:
Suppress Single Item Subtotals
If it is something different please let us know. This was added to handle this case of subtotals that are only a single line
1 -
@LAFligg and @TaddGibson did you see the comment above from May 22nd? Will this help?
0 -
The suppress single line subtotals work up to a certain point and with certain limitations from what I've tested in the past:
- Sometimes you want some subtotals to show even when there is a single line, to drive consistency in presentation. In Mark example the second block (104471) is the perfect representation of this, if you select the remove single line subtotals then that will be presented differently than all of the other entries. Which makes it less intuitive and harder to read for the untrained eye.
- For this to work you need to make sure you put the line that makes it unique in the right position from left to right as of when you want to stop the groupings from happening (usually a unique identifier to the highest level of granularity to be displayed). Which might not always align with what the desired order of the output is.
Having an option to select how many levels of Subtotals we want would be ideal and grant the level of customization many users are looking for.
Visually if our Dataset would be something like this:
And we want our Pivot table to show the columns in the following Order: Customer > Month > Invoice > Total, but we want our Subtotal Rows only to be present at the Customer level and to always be present at that level, without the Suppress single line totals we get:
If we select the option, then we still get subtotals at the month level when there are multiple invoices and we lose the Total row for Customer C.
If we rearrange to have the Invoice as the second column (highest granularity) we do get all subtotals to only be for the first column, but still miss to have one for column C (this is way more noticeable if you style your subtotal rows, which I've done in this last screenshot to better illustrate how those can easily be missed)
As you can see it'll be hard for the untrained eye to know that the C row has the same level of importance as the A Total since it's not even highlighted in the same way.
1 -
I agree that the single line suppression does NOT do the job. It helps in rare cases, but generally just makes things more confusing.
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thank you @Gavatar, we are already using the Suppress Single Item Subtotals functionality but as @marcel_luthi points out, it does not always provide the desired outcome.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive