Absolutely agree! this would add a lot of value. Often times we give up on the totals even when we really need to show them because we don't have space to show both, especially when being used in dashboard. Plus we're losing a bit of trust with our users when we say "this is how it works" because it's looks silly.
I have Pivot tables that need totals. However, 99% of the time, the Total only makes sense for either the columns or the rows. Having to include both shows a row or column that is irrelevant
Greg Lyons
over 3 years ago
in Reports
0
Future consideration
4
MERGED
Ability to enable/disable row/column calculations independently in pivot view
Merged
Currently the calculation based on cell values (e.g. sum, average, count, etc.) is enforced in both the row and column direction. This is not always desired. The column totals could make sense whereas the row calculation don't as the fields they r...
Guest
about 4 years ago
in Reports
1
Future consideration
Absolutely agree! this would add a lot of value. Often times we give up on the totals even when we really need to show them because we don't have space to show both, especially when being used in dashboard. Plus we're losing a bit of trust with our users when we say "this is how it works" because it's looks silly.
This would be great to have. I often do not need to show both.
In addition, would really appreciate the ability to have % of total as an option in how to summarize the columns or rows.
Yes! Please make this happen. I normally want to hide the row totals or the column totals. Rarely do i want to show both!