How can you have two pivot tables on one worksheet?

[trainer07]

Is it possible to have multiple pivot tables on one worksheet? The various
pivot tables will be using the same source data. I just want to show
different things with each one. Thanks!

 

[Eduardo]

Hi,
Just you can copy the PV under the other one and then select the fields you
need

 

[Herbert Seidenberg]

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.