View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
auntmarsa auntmarsa is offline
external usenet poster
 
Posts: 1
Default Pivot Table-two tables same data, can I used the same page control

On one page, I have a pivot table that shows total dollars by category, then,
below it I have a copy of that pivot table that calculates dollars/sq ft. Is
there any way that these two tables can be controlled by the same Page
choices. So, if I filter on a different country, it will change both the
first and second tables.