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