asked on

Grand total a pivot table column of minimum values

How do I get Excel 2007 to sum a column of minimum values in the Grand Total line of a pivot table? I have attached an image of the sample pivot table I'm working with. I'd like to total the two columns whose labels start with "Min" in the Grand Total line. Is this possible? Currently the Grand Total line returns the minimum value for each of the "Min" columns. I want the sum of the values that appear in each of the "Min" columns to appear in the Grand Total line of the pivot table.
Sample-Pivot-Table.png

ASKER CERTIFIED SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bvallanc

ASKER

Is there a reason why I can't place anything beneath the pivot table? Doesn't the SUB return Target as the pivot table that's being edited? I'd like to place multiple pivot tables beneath each other if that's possible.

Thanks,

Bill Vallance

Patrick Matthews

Bill,

It's because, as the PT updates, if it grows or shrinks the row I write the totals to will change.

In any event, any time a PT can increase in rows over time, it is a bad idea to put anything under it.

Patrick

bvallanc

ASKER

Excellent response to what I thought was something simple but turned out to be more complictaed than I expected!