asked on 5/17/2011

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

Microsoft Excel

Last Comment

bvallanc

5/18/2011

ASKER CERTIFIED SOLUTION

Patrick Matthews

5/17/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

SOLUTION

Patrick Matthews

5/17/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

bvallanc

5/17/2011

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

5/17/2011

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

5/18/2011

ASKER

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