Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |