combining pivot tables

kmiles · Apr 2nd, 2002, 08:05 AM

Is there a way to combine two or more pivot tables with the same structure but different data sets into one pivot table?

I know you can use one pivot table as a source for another, but can I use two as the source?

Thanks for any help.

Mark W. · Apr 2nd, 2002, 08:43 AM

Not really... but, you could source a PivotTable from a query which Unions the two data sets.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 08:05 AM	#1
kmiles Board Regular Join Date: Apr 2002 Posts: 113	Is there a way to combine two or more pivot tables with the same structure but different data sets into one pivot table? I know you can use one pivot table as a source for another, but can I use two as the source? Thanks for any help.

Apr 2nd, 2002, 08:43 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Not really... but, you could source a PivotTable from a query which Unions the two data sets.