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
     
    Debra Dalgleish, May 26, 2005
    #2
    1. Advertisements

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Greg Cotten

    Multiple Pivot tables to Pivot Chart

    Greg Cotten, Aug 8, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    25,859
    Jon Peltier
    Aug 9, 2003
  2. Jason

    pivot table with multiple pivot tables as source

    Jason, Dec 18, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    2,620
    Debra Dalgleish
    Dec 21, 2003
  3. tomo999

    Pivot tables on pivot tables!

    tomo999, Jan 15, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    713
    Roger Govier
    Jan 15, 2004
  4. Guest
    Replies:
    1
    Views:
    546
    Ken Wright
    Feb 17, 2005
  5. Guest
    Replies:
    0
    Views:
    598
    Guest
    Apr 20, 2006
  6. Gordo
    Replies:
    0
    Views:
    361
    Gordo
    Dec 11, 2006
  7. Replies:
    4
    Views:
    1,980
    iliace
    Dec 26, 2007
  8. 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:
    194
    Gord Dibben
    Apr 10, 2010
Loading...