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.
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 line1
@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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 212 Visualize
- 258 Beast Mode
- 2.1K Charting
- 12 Variables
- 85 Cards, Dashboards, Stories
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 248 Distribute
- 64 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 184 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive