can I create pivot table from two other pivot tables?

  • Thread starter Thread starter pjk@boro
  • Start date Start date
P

pjk@boro

The two tables are created from separate data sources & I don't want to add
these data sources together.
 
The only way to do what you have asked is to combine the two data sources.
There is no way to join two pivot tables.
 
The two tables are created from separate data sources & I don't want to add
these data sources together.
Click to expand...

A pivottable source query can add the data from two separate sources
together without physically combining the data sources. Is that what
you want?

Ian
 
In addition to Jim's correct reply, you can generate multiple pivot tables
from the same dataset as a previously existing one. This not only gives you
an additional way of analyzing your data it saves you some considerable ram
resources as well.
 
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

Pivot tables - memory issues - please help 2
pivot table data 2
Pivot Table Data Source 1
How can I change the source data reference to another pivot table? 2
Pivot Table Variance 2
Adding to an existing Pivot Table 7
Excel Pivot Tables 1
Pivot table, IF function, calculated item versus calculated field 1

Back
Top