I have problem connect the slicer. Department slicer works well but work country and region cannot connect Pivot Table 1 and 2
I have problem connect the slicer. Department slicer works well but work country and region cannot connect Pivot Table 1 and 2
Try following steps:
1. add offending Slicer fields to both Pivots (temporarily)
2. right click on newly added field name, check/uncheck "Include New Items in Manual filter" (i.e. opposite of default setting)
3. click OK
{should get a dialog at this point that change will be applied to both Pivots etc}
repeat steps 2 & 3 if you want to revert to the original setting by reinstating original checkbox status (checked/unchecked)
then, finally
4. remove the fields added (Step 1) from Pivot
5. amend connections on both slicers to include 2nd Pivot
in short, the settings for the field(s) on both Pivots is different -- the above will bring the settings into line such that the slicer can be activated on both Pivots.
Last edited by XLent; 04-23-2019 at 11:28 AM. Reason: added comment re: optional step(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks