LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Data Adding contents of two pivot tables and param que Roundy Excel Discussion (Misc queries) 0 July 2nd 07 10:20 PM
Summin Pivot Table data from a date selected in the Page field John Excel Discussion (Misc queries) 1 November 10th 06 10:32 PM
Central control for pivot tables dcozzi Excel Discussion (Misc queries) 1 March 17th 06 09:51 PM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 PM
Updating Page Field of Pivot Tables from Form Control RestlessAde Excel Discussion (Misc queries) 1 August 3rd 05 09:00 PM


All times are GMT +1. The time now is 12:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"