Combine several pivot tables into one (Excel 2003 / SP1)

Topic

New Reply

I have 2 separate sheets that are data sources. On a total report sheet, I have pivot tables showing the results of each sheet. I want to combine the pivot tables into a “total” pivot table. I’ve tried the source data as both “mutiple consolidation ranges” and “another pivot table report.” I just can’t seem to get there. What am I missing?

Reply | Quote

Replies

I think it would help if you posted an example of the 2 sources and what you want the results to look like.

Steve

Reply | Quote

The highlighted yellow section is the totaled area. Those are the combo tables that I’m looking for.

Reply | Quote

Steve asked if you could post the source data.

Reply | Quote

If you want to just combine the 2 pivots you just need to set the 2 pivot table ranges as the consolidation ranges

For the first table the 2 consol ranges are:
Sheet1!$A$9:$B$10
Sheet1!$D$9:$E$10

Make sure you uncheck under options “Grand totals for row” then the pivot wil be like the output in G/H

The second is done similarly with the ranges:
Sheet1!$A$22:$B$25
Sheet1!$D$22:$E$24

Am I missing something?

If you want something based on the “raw data” I would have to see how they are setup to give any suggestions.
Steve

Reply | Quote