Forum Discussion
Solved
Create a slicer linking 2 pivot tables from different worksheet
I am trying to create a slicer linking 2 pivot tables from different sources as shown in the file attach. However I keep getting message that my column have duplicate values. Basically I am trying to...
Liphor There were a couple of issues in your file:
- The Append query contained two columns because you renamed the Catch column in one of its sources
- The append query then needed a filter for unique values
- The pivot tables need to be using the fields from the unpivoted table queries, not from the original tables
- The Catch field for each pivot needs to be taken from the Appended Catch query, NOT from the table or the unpivoted table query
- The slicer then needs to be on that Catch field and tied to both pivot tables.
See attached.
JKPieterse I try to follow your instructions but I am not able to link the splicer to one of the pivot even though I have managed to connect both tables. Attached is my file.
You seem to have uploaded an empty workbook?
JKPieterseOops sorry .Here is the attached file.
Liphor There were a couple of issues in your file:
- The Append query contained two columns because you renamed the Catch column in one of its sources
- The append query then needed a filter for unique values
- The pivot tables need to be using the fields from the unpivoted table queries, not from the original tables
- The Catch field for each pivot needs to be taken from the Appended Catch query, NOT from the table or the unpivoted table query
- The slicer then needs to be on that Catch field and tied to both pivot tables.
See attached.
JKPieterseI am finally able to follow the instructions given by you. I would to know whether do I always have to create a unique query to different tables and append them together. How do I sort the months in calendar type order. Thank you very much and really appreciate your help.