+ Reply to Thread
Results 1 to 1 of 1

Trying to link 2 pivot tables "Show Detail" fields

  1. #1
    Registered User
    Join Date
    04-08-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Trying to link 2 pivot tables "Show Detail" fields

    Hello everyone,

    I need help figuring out how to join / link 2 pivot tables so when 1 "drill down" button is checked the corresponding button on the adjacent is also checked.

    Both tables pull the same data from a different worksheet that pulls a SQL query.
    Here a picture to help visualize my problem. ptTables.PNG

    Here is code I found that I believe changes values to same on either table, but I was having a hard augmenting this to change the "Show Detail = True / False" option
    Please Login or Register  to view this content.
    Using macro recorder here is the code that changes once a drill down button is clicked
    Please Login or Register  to view this content.
    I was thinking I could change the code I found to see once the PivotTables("").PivotFields("").PivotItems("").ShowDetail value is changed then the other value is changed. Problem is I'm not sure how to capture which PivotItem had its value change.

    I figured out the code to collapse all in a related macro to be this (if that helps):
    Please Login or Register  to view this content.
    I was hoping I could figure this out, but alas I am just a simple excel programmer and still use the macro recorder to learn new functions

    ...Now an alternative would be to move that "Production Quanity" Field to a value field in one single pivot table, but then that would require me to figure out code to insert a new line after each "partnum" block in my data table. If none of that makes sense, I also attached an excel file
    Attached Files Attached Files
    Last edited by jlab89; 01-21-2013 at 04:44 PM.

+ 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