+ Reply to Thread
Results 1 to 4 of 4

2 Pivot Tables

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    2 Pivot Tables

    Hi there,

    Looking for a way to solve this:
    - I have 1 pivot table in which I have data according to my selection of the product ("pear", "apple", etc).
    - I have a second Pivot Table that gives me other information on the same selection of product.

    I can not combine the 2 pivot Tables because they take data from different lookup tables (one pivot is actually looking at a monthly view, the second one at a yearly view).

    However, I would like to know how I could automatically get the data for "apples" in the second pivot when I choose "apples" in the 1st (so that both pivot show data of the same fruit). Currently I have to choose "apple" in the 1st pivot and then manually choose "apples" in the second pivot.

    Any idea?

    Thanks for help.

  2. #2
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Re: 2 Pivot Tables

    you could do this using VBA programming code, can you please upload a sample of your workbook?
    --
    Regards
    PD

    ----- Don't Forget -----

    1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks

    2. Thank those who have helped you by Clicking the scales above each post.

    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

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

    Re: 2 Pivot Tables

    Hi neocuproine,

    I have some code behind the worksheet I wrote a while back that does what I think you want. Find the attached with an example of what I think you want.

    If you change the filter of any of the three pivot tables the other two will syncronize to that filter.
    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
    06-09-2011
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: 2 Pivot Tables

    Thanks! That's great!

+ 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