P
pjk@boro
The two tables are created from separate data sources & I don't want to add
these data sources together.
these data sources together.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Thomlinson
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.
There is no way to join two pivot tables.
I
Ian
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
H
Herbert Seidenberg
Excel 2007
See example.
Certain restrictions apply.
http://www.mediafire.com/file/yzdrzrndyce/06_12_09.xlsx
See example.
Certain restrictions apply.
http://www.mediafire.com/file/yzdrzrndyce/06_12_09.xlsx
K
Kevin B
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.
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.
P
pjk@boro
That might do it. I'll give that a try. Thanks V much.