| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate Pivot Tables
Do you know how to use the Consolidate feature on Pivot Tables? For example,
I have a worksheet with a pivot table for Sales and a pivot table for Cancels. I want to create a consolidation of these two pivot tables so I can calculate a "Net" section. Do you have any idea whether this is possible? Right now I am using the GETPIVOTDATA function and want to know if there is any other way that is easier. Thanks! JS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
| Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
| how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
| Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Threaded Mode
