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
    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
    Mar 23, 2020

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

  • Laura Spohn
    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
    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

Ability to enable/disable row/column calculations independently in pivot view

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

Pivot table - split option for Summary Row/Column

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 almost 3 years ago in Reports 0 Future consideration