Add MAX & SUM in pivot Table

[domtrump]

How can I create a calculated field in a pivot table (Excel 2007) that adds one row that has a value filed setting of MAX to another row that has value field setting of SUM? I know that the pivot table always uses SUM in calculated fields by default, but I'm hoping someone has discovered a work around.

Thanks.

 

[Fazza]

Hi, it would help if you post some sample data. regards