Feb 04 2019 05:37 AM
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 !
Feb 04 2019 06:10 AM
Hi,
You may slicer your source table and that filter affects Pivot Table as well. Not in opposite direction.
Feb 04 2019 06:23 AM
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 ?
Feb 04 2019 06:31 AM
You can't connect to both, you may filter source table and Pivot Table will work on filtered table