bacon4life
Electrical
- Feb 4, 2004
- 1,532
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