+ Reply to Thread
Results 1 to 4 of 4

Pivot table, changing the criteria in the parent table

  1. #1
    Registered User
    Join Date
    12-24-2006
    Posts
    32

    Pivot table, changing the criteria in the parent table

    HI All I was wondering if there was a way to create a parent pivot table and 2 children based on the first pivot table, and when you change the criteria in the parent table the children pivot table changes accordingly to those criteria changes?
    Can this be done? Will this need to be done in VB?
    Thanks
    James
    Last edited by James_SF; 05-05-2011 at 11:35 AM.

  2. #2
    Registered User
    Join Date
    03-17-2011
    Location
    Illinois
    MS-Off Ver
    2007-2010
    Posts
    22

    Re: Pivot table, changing the criteria in the parent table

    This might do what you're looking for.
    http://www.techonthenet.com/excel/macros/refresh_pt.php

    You should add lines to refesh the other pivot tables in your workbook.
    Pete

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Pivot table, changing the criteria in the parent table

    Hi James,

    This is similar (perhaps) to a question from a few weeks ago. Find my attached answer. If you change the filter of any of the pivots it will change the other two pivot tables to be the same filter.

    If this is useful, I'd like to have an example of how you are using this feature.

    If not then I'm thinking you could create a Dynamic Named Range where your first pivot table was possitioned and use that named range for your other two child pivot tables.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    07-16-2007
    Location
    San Francisco, CA
    MS-Off Ver
    2010
    Posts
    93

    Wink Re: Pivot table, changing the criteria in the parent table

    Thank you for our solutions.
    Both solutions work like you have presented however, Melvin was what I was after and not to adapt it to my needs.
    Thanks once again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1