MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Multiple Pivot Tables


Posted by mcs on April 06, 2001 8:06 AM

I have two pivot tables. One has demand and the other has shipments.

In both tables the customer code is in the page area. I would like to be able to change the customer code in the demand table and have the shipment table change automatically to the same customer.

Is this possible?


Posted by Mark W. on April 06, 2001 9:23 AM

See...

Posted by mcs on April 06, 2001 10:31 AM

Re: I don't understand

I am sorry. I don't understand how to do that. I don't know how to 'replace Fruit with Selected Fruit'. How do you do that?

Posted by Mark W. on April 06, 2001 12:09 PM

Re: I don't understand

Using the PivotTable Wizard you drag the 'Selected Fruit' field
to the PAGE area and remove the 'Fruit' field.