How can you have two pivot tables on one worksheet?

  • Thread starter Thread starter trainer07
  • Start date Start date
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!
 
Hi,
Just you can copy the PV under the other one and then select the fields you
need
 
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.
 
You must log in or register to reply here.

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

Similar Threads

One pivot table for multiple worksheets/tabs 2
Pivot Table Data Source 1
Single Filter to change all Pivot Tables in a Workbook 8
Pivot table data source 1
Pivot Table Update 3
pivot table data 2
Pivot Table date format 1
Are copied Pivot Tables "linked" to each other ? 2

Back
Top