Skip to Main Content
Status Future consideration
Categories Reports
Created by Guest
Created on Dec 9, 2020
Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit AFPR-I-7776 Enable/disable row/column calculations independently in pivot tables.

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 represent have different meaning. It would be a good change to decouple the row and column calculations and manipulate them independently.

  • John Michaels
    Reply
    |
    Jul 7, 2021

    I want to provide a pivot that is meaningful with a sum total of records at the bottom. The sum number showing to the right of a row is meaningless and just causes confusion. I need to be able to hide that far column.