View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Oleg Oleg is offline
external usenet poster
 
Posts: 1
Default Change Multiple Page Fields in two independent Pivot Tables

I have two independent Pivot Tables. Pivot Table 1 and Pivot table 2
- with different data sources. There is a one field which is
identical in both Pivot Tables - Territory. The Territory is the page
field in both Pivot tables and includes same items. Can I change the
page field item in Pivot Table 1 by selecting an item in Pivot
Table's 2 page fields? I need to get the same Items in both Pivot
tables.