Forum Discussion
catiabd
Feb 04, 2019Copper Contributor
Slicers Connect
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 !
SergeiBaklan
Feb 04, 2019Diamond Contributor
Hi,
You may slicer your source table and that filter affects Pivot Table as well. Not in opposite direction.
catiabd
Feb 04, 2019Copper Contributor
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 ?
- SergeiBaklanFeb 04, 2019Diamond Contributor
You can't connect to both, you may filter source table and Pivot Table will work on filtered table