Combining multiple pivot tables
 

OK, I'm trying to create some type of report card.

Say I have multiple pivot tables, all having the same general Rows or Pages
defined (region, state and individual). However, each of these pivots have
a different set of columns and data.

I'd like to create a master pivot table that will contain all of the data
from the 3 or 4 ther pivot tables. So all measured data will be present at
the Column and Data level for each visible Row.

Any ideas?

Combining multiple pivot tables
 

You can use the GetPivotData function to extract data from a pivot
table. Perhaps you could use it to pull data and total the results.

There are instructions and examples in Excel's Help, and he

http://www.contextures.com/xlPivot06.html

EasleyK wrote:
OK, I'm trying to create some type of report card.

Say I have multiple pivot tables, all having the same general Rows or Pages
defined (region, state and individual). However, each of these pivots have
a different set of columns and data.

I'd like to create a master pivot table that will contain all of the data
from the 3 or 4 ther pivot tables. So all measured data will be present at
the Column and Data level for each visible Row.

Any ideas?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html