Forum Discussion
Pivot Tables With a Slicer
I am using Excel 2019. How do I sync a slicer from 2 different data set to work with 2 pivot tables. The filter connection is good, the relationship is good. I am not getting any error messages and m...
1) Hide Applicant FullName on many side of relationships (i.e. in App_Pref_Locations and DMAT_App). As a comment, first to after relationship was built is to hide the field on many side, that's considered as best practice.
2) In PIvotTables use Applicant FullName only from FullName table. Previous step was only to prevent unintended use of such field from fact tables.
With that slicer shall work on both PivotTables.