slicer automatic selection of not chosen item

[Maxwolf]

ok, i have 2 slicer, and i would like when we choose items in the first slicer than automatically selected in the secon slicer ,items who has not been choosen in the first slicer .

there is the file.

 

[GraH - Guido]

Hmm, that is not really how slicers work. They can only "synchronize" when they share the same pivot cache. But in this case is is about the same column and the same slicer. They would be the same.
A workaround would be using a helper column. And make a second pivot on that extended range. You would need to refresh the second pivot first. On the second slicers you would see the item values that are not selected in the first one, first (the selected items are at the bottom, in lighter shade). Or insert some macro to avoid manual refresh.
Not sure this is actually what you are after though.

 

[Maxwolf]

Thank you that will do the work.

 

[Chihiro]

If you have Excel 2010 and up, base your pivot table on OLAP model.

Then you can use VBA and .SlicerChaches(Index#).VisibleSlicerItemsList to capture selected items on the first and apply converse selection to second.

If using older version. I would recommend going with GraH - Guido's method. Since there is no available list of visible item and you'd need to loop through each field item.