Skip to Main Content

Share your product feedback

Status Future consideration
Categories Reports
Created by Greg Lyons
Created on Apr 14, 2021

Pivot changes - adjust calculation row and/or column independently

Currently with a Pivot chart you can choose to include a Total row AND column. For many pivot charts, only one of these makes sense and the other is useless space wasting data.

  • Attach files
      Drop here to upload
    • Lindsay Lawler
      Reply
      |
      Mar 20, 2025

      Being able to select either a row or column total would be incredibly valuable (instead of being forced into both). Right now, this is creating a lot of "visual noise" on my dashboards or general reporting with duplicative numbers and also additional "size" of the panels on the dashboard. I find myself most commonly seeking only the summary row vs the summary column, but there are use cases for each.

    • Eliza Crawford
      Reply
      |
      Nov 6, 2024

      In some pivot tables we only want to see the total for the column, not the row - can you please implement this functionality so that we can decide whether to show total for the row, column, or both in pivot tables?

    • Guest
      Reply
      |
      Jul 6, 2023

      Found another reason this is necessary - I can only sort the pivot rows by the cell calculation if a total is included. So I have to include the summary row/column so I can then sort the entire pivot table by the cell calculation.

    • Guest
      Reply
      |
      Mar 14, 2023

      I am using a pivot table to include two similar but unrelated data points so having a row summary creates confusion. I do want the column summary though.

    • Gene Lewin
      Reply
      |
      Oct 13, 2022

      I would think this is an easy one to add, and would make pivot reports way more useful for me. For example, right now I have a pivot report with 2 columns, one of which is a feature count, and the second of which is a subset of that feature count where a certain field is populated. I very much want the column totals (which show me the total number of features regardless of that field's value), as well as the total number of features where that field is populated, but the row totals are meaningless.

    • +2
    22 MERGED

    Having different calculation methods on pivot tables by 'row' and 'column'

    Currently if you select 'Calculate' method for a pivot table it applies it to both row and column, however this isn't always logical. In the example of selecting 'difference' you might want the difference at a row level to show difference between ...
    Guest over 8 years ago in Reports 4 Future consideration
    27 MERGED

    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.
    Paul Dickie almost 6 years ago in Reports 4 Future consideration