How can you have two pivot tables on one worksheet?
To uncouple multiple PivotTables,
convert the common source List/Table into a range and
give the same range two or more different defined names.
(Include header range)
Go to the source definition for each PT
and enter a different source name for each PT.
Turn the source range back into a
Excel 2007 Table or Excel 2003 List.
|