Different Field Summaries in Pivot Table from Consolidated Range

[unclesam]

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am consolidating 7 data ranges into one pivot table. Each data range looks like this:<o></o>
<o></o>
Item Backorder Age of Oldest Order<o></o>
Item 1 Quantity 1 Age 1<o></o>
Item 2 Quantity 2 Age 2<o></o>
Item 3 Quantity 3 Age 3<o></o>
… … …<o></o>
Item n Quantity n Age n<o></o>
<o></o>
‘Item’ is a text field, ‘Backorder’ and ‘Age of Oldest Order’ are integer fields. All 7 ranges have identical structure and headers. In the consolidated pivot table, I want to Summarize value field ‘Backorder’ by SUM and Summarize value field ‘Age of Oldest Order’ by MAX. I would appreciate it if I could get some guidance on how to achieve this. Currently the Pivot Table from Consolidated Range only allows me to Summarize fields in the same way, i.e. I can either SUM both fields or Max both fields, I cannot Summarize them individually.<o></o>
<o></o>
Thanks,<o></o>
Sam.

 

[Fazza]

Hi, Sam

This http://www.mrexcel.com/forum/showthread.php?t=315768 should cover all you need.

Note though that thread started with a specific question for a code solution. Later in thread is the information that can help you - there is a bit of info to 'plough' through so it may not be as simple as you're expecting. Please post again as required.

HTH, F