Pivot table with row grand total and column grand average
Pivot table with row grand total and column grand average
(OP)
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.
CODE
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
RE: Pivot table with row grand total and column grand average
I put table aggregations at the TOP of my sheet, above the table, and turn off the column totals in the PT.