Pivot table with row grand total and column grand average

[bacon4life]

Can a pivot table be configured to have the Grand Total field be a SUM for each row, but a MAX for each column? I can work around it by putting the MAX function outside of the pivot table, but seems like there should be built in way to do it.

Example desired data table:

Jan bob sue pat SUM
feb 100 200 300 600
mar 150 250 100 500
apr 250 200 100 550
MAX 250 250 300

 

[SkipVought]

hi,

I put table aggregations at the TOP of my sheet, above the table, and turn off the column totals in the PT.