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.
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.
- Filter fields in a pivot table from the data model need to come from a table which contains only unique items of all tables you are filtering on. I'm no data model expert, I'm sure if you google for the month sorting problem you'll find the answer, which I expect will revolve around creating a date table using a query.
- Thank you again for your help