combining pivot tables

[kmiles]

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

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