How can you have two pivot tables on one worksheet?


T

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!
 
Ad

Advertisements

E

Eduardo

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

Advertisements

H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top