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
Bookmarks