Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I combine two pivot table?
Hi, I have two database with the same column but different rows. Both
database contains $ amount for 12 months for different products. I want to build one pivot table which compares the $ variance of the same product category for 12 months. How do I do that? I can build two pivot tables and copy the value of both pivot tables and do a formula, but that's not what I want. I want to be able to navigate the pivot table and compare different product category levels. Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I combine two pivot table?
I think you will have to make one table and classify the data by date to do
this comparison in a single table. You might be able to copy and paste special value, then do vlookups across the results? -- David "Lisa" wrote: Hi, I have two database with the same column but different rows. Both database contains $ amount for 12 months for different products. I want to build one pivot table which compares the $ variance of the same product category for 12 months. How do I do that? I can build two pivot tables and copy the value of both pivot tables and do a formula, but that's not what I want. I want to be able to navigate the pivot table and compare different product category levels. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to combine two excel worksheets in one pivot table. | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Can I combine two worksheets into one pivot table? | Excel Worksheet Functions |