Hi I hope i can make this as clear as possible. I have 3 tables in a work sheet all of which have data that relates to various cycles throughout the year. I have created connections between table 1 and table 2 using a merge query and the joining field is “Subject”. I have made a connection between table 2 and 3 using another merge and have linked this using A field called “Cycle ID” I have then made a connection between table 1 and 3 using another merge using “Cycle”as the linked field. I then create Merge Query and output to a worksheet and called this “Mergefinal”
Now when i look at all the queries the data is as it should be and changes according to the cycle i select. However when creating various pivot tables using “Mergefinal” as the source the only pivot table that will not refresh is the one that contains data connected to the cycles. In other words if i use a slicer and choose either of the cycles, every other pivot table refreshes except one. So “cycle 1” and “cycle 2” should be a different value for “subject A”.
I hope this makes sense.
Bookmarks