Multiple Pivot Tables with single Page Field

Discussion in 'Microsoft Excel Misc' started by cscribner, May 25, 2005.

  1. cscribner

    cscribner Guest

    I've got two pivot tables on a sheet, one showing the selected week'
    totals, and the other showing the month's totals. I want to link thes
    two tables to update automatically--if someone selects the week o
    4/24/2005, then I want the other table to automatically select Apri
    2005. What's the trick to doing this?

    thanks!
    Crai

    --
    cscribne
    -----------------------------------------------------------------------
    cscribner's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2366
    View this thread: http://www.excelforum.com/showthread.php?threadid=37409
     
    cscribner, May 25, 2005
    #1
    1. Advertisements

  2. You can do this with programming. There's a sample file here:

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

    Under Pivot Tables, look for 'Change Page Field'

    cscribner wrote:
    > I've got two pivot tables on a sheet, one showing the selected week's
    > totals, and the other showing the month's totals. I want to link these
    > two tables to update automatically--if someone selects the week of
    > 4/24/2005, then I want the other table to automatically select April
    > 2005. What's the trick to doing this?
    >
    > thanks!
    > Craig
    >
    >



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html
     
    Debra Dalgleish, May 26, 2005
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Greg Cotten

    Multiple Pivot tables to Pivot Chart

    Greg Cotten, Aug 8, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    12,876
    Jon Peltier
    Aug 9, 2003
  2. tomo999

    Pivot tables on pivot tables!

    tomo999, Jan 15, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    385
    Roger Govier
    Jan 15, 2004
  3. Guest
    Replies:
    1
    Views:
    348
    Ken Wright
    Feb 17, 2005
  4. Replies:
    4
    Views:
    1,656
    iliace
    Dec 26, 2007
  5. TheTraveler

    I need to link 4 pivot tables that are on a single page.

    TheTraveler, Apr 10, 2010, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    168
    Gord Dibben
    Apr 10, 2010
Loading...

Share This Page