can I create pivot table from two other pivot tables?
 

The two tables are created from separate data sources & I don't want to add
these data sources together.

can I create pivot table from two other pivot tables?
 

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.
--
HTH...

Jim Thomlinson


"pjk@boro" wrote:

The two tables are created from separate data sources & I don't want to add
these data sources together.

can I create pivot table from two other pivot tables?
 

On 12 June, 14:19, pjk@boro wrote:
The two tables are created from separate data sources & I don't want to add
these data sources together.

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

can I create pivot table from two other pivot tables?
 

Excel 2007
See example.
Certain restrictions apply.
http://www.mediafire.com/file/yzdrzrndyce/06_12_09.xlsx

can I create pivot table from two other pivot tables?
 

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.
--
Kevin Backmann
Dallas, TX


"Jim Thomlinson" wrote:

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.
--
HTH...

Jim Thomlinson


"pjk@boro" wrote:

The two tables are created from separate data sources & I don't want to add
these data sources together.

can I create pivot table from two other pivot tables?
 

That might do it. I'll give that a try. Thanks V much.

"Ian" wrote:

On 12 June, 14:19, pjk@boro wrote:
The two tables are created from separate data sources & I don't want to add
these data sources together.

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