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.
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.