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