Skip to Main Content
Status Future consideration
Categories Reports
Created by Paul Dickie
Created on Jun 7, 2019

Enable/disable row/column calculations independently in pivot tables

Option to have column or row data as totals.  Current design always shows both which can cause issues when you do not want a row total.

  • Attach files
  • Reut Levi
    Reply
    |
    Mar 17, 2021

    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.


  • Guest
    Reply
    |
    Mar 23, 2020

    This would be great to have. I often do not need to show both.

  • Laura Spohn
    Reply
    |
    Feb 27, 2020

    In addition, would really appreciate the ability to have % of total as an option in how to summarize the columns or rows.

  • Jeffrey Heilbrunn
    Reply
    |
    Jan 17, 2020

    Yes! Please make this happen. I normally want to hide the row totals or the column totals. Rarely do i want to show both!

  • +1
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 3 years ago in Reports 1 Future consideration
1 MERGED

Pivot table - split option for Summary Row/Column

Merged
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 2 years ago in Reports 0 Future consideration