Skip to Main Content
Status Future consideration
Categories Reports
Created by Guest
Created on Sep 21, 2016

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 'Feature original estimate' and 'feature logged effort'.  However at the column level I would want to see all the times 'summed' for: 

  • Feature original estimates
  • Feature logged effort
  • Difference summed up

Therefore, could we please be able to control the 'Calculate' on a pivot table for column/row independently.



  • Attach files
  • Matt Y
    Mar 27, 2024

    We have a list of ideas in a pivot table and we want to also show in the columns vote count, org count, and ARR. The latter pulled from salesforce integration. We want to then change the filter based on a specific date field which is also tied to salesforce integration data (churn date). We can do this with vote count and ARR in the columns as sums. However, if we put the org count, since it is locked to "sum" then this value is not correct. We want this value to be "count unique records". By defining how each column has the "Within cells list as" then we can have more granular ability. I'm surprised this isn't a common request since I would think many people would want to know ideas by vote count, org ARR, and # of orgs associated to that idea and being able to filter by relevant churn dates

  • Andras Blake
    Jun 13, 2022

    Just being able to hide the total column, leaving a total row at the bottom, would be super useful.

  • Rachel Collins
    Feb 26, 2019

    Please add this functionality soon as well as the ability to display $ sign when totaling values in a pivot report.

  • Guest
    Sep 21, 2016

    This would be really useful, because as it currently stands it does not make sense logically.

  • +1