How to filtering additional fat sets along with a pivot table

I have a few different data sets of sales based on different time periods and sorted by salesperson. I have a pivot table based on data set 1. The other data sets are also by salesperson but different time periods. How can I get the additional data sets to filter alongside the original data set as it’s filtered by salesperson? I tried adding a slicer but couldn’t get the relationships to work because t said I have duplicates. I don’t know why any duplicates would exist because the data is pulled difectly from our customer software system. Any suggestions?