Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) |