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 !
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