Consolidate Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table 2
pivot tables 2
Consolidate Pivot table from multiple files 4
Consolidated Pivot table 1
Rolling Forward Pivot Table Source Data 4
Multiple Pivot Tables from Same data source 1
Consolidate tables/ranges with text from multiple worksheets 1
Pivot table not recognizing same field values 1

Back
Top