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