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
Using macro recorder here is the code that changes once a drill down button is clicked
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):
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
Bookmarks