You can do this with programming. There's a sample file he

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

Under PivotTables, look for 'Change Page Field'


Kreed wrote:
I was able to create a pivot table using an established pivot table; however,
the established pivot table has filters (created using the PAGE area of the
layout). I was hoping that when the established pivot table is filtered on
(thus changing the data within the pivot), it would update the newly created
pivot with the same filters. Is there something I should do that would
acheive what I desire in this second pivot table? Thanks!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html