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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate Pivot Tables
Perhaps you could combine the source data and add a column to indicate
if the transaction is a Sale or Cancel. Then create one pivot table from all the data. JS wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
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) |