This seems like something that should be possible in a PivotTable, but I can't figure it out. Maybe I'm missing some completely obvious menu.
I'm building a pivot table report that looks something like this:

Location A Location B Total Qty Total $ Value
ItemCode Qty $ Value Qty $ Value
Item1 10 $100 20 $200 30 $300
Item2 10 $50 50 $250 60 $300
Item3 5 $35 5 $35 10 $70


Without manually hiding columns, I am trying to format it like this:

Location A Location B Total Qty Total $ Value
ItemCode Qty Qty
Item1 10 20 30 $300
Item2 10 50 60 $300
Item3 5 5 10 $70

That is, I don't want to show the 'detail' of the $ Value column for each location, but I still want to have it totalled up on the right. Is this possible?

(The reason I don't want manually hide columns is because the number of locations may change in each report, meaning manually-hidden columns may not match up correctly)