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)
Bookmarks