Slicers Connect

Copper Contributor

Hello,

I need your help with slicers. Is there anyway of connecting the pivot slicers with the source table. Ideally I would sort the Pivot and the table at the same time.

 

Thank you very much !

3 Replies

Hi,

 

You may slicer your source table and that filter affects Pivot Table as well. Not in opposite direction.

Hi Sergei, Tks, 

 

I have tried to connect the table slicer with the pivots, but i cannot do it, how can I make that connection work and affect the pivots with the slicer created in the table source? Can you help me ?

You can't connect to both, you may filter source table and Pivot Table will work on filtered table