Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table comparison
Ok new question! I've been trying to work this out, but i havent been
successful. I want when i select the Quarters to be displayed on one pivot table, that those quarters be the same ones displayed on all the pivot tables. I know i have to use PivotTable("name"), PivotField("Quarters") and then use PivotItems.visible = true. I have to have one for my source data and then one that will be changing to do the comparison, but I'm not exactly sure on how to loop through the pivotitems and compare that to my main pivotitems. If you need a better explanation please let me know, these pivot table issues are pretty complex. Thanks, Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Comparison | Excel Worksheet Functions | |||
pivot table comparison | Excel Discussion (Misc queries) | |||
Pivot comparison | Excel Discussion (Misc queries) | |||
Pivot Table row comparison | Excel Discussion (Misc queries) | |||
how do I set up a fast comparison table? | Excel Discussion (Misc queries) |