Home

Slicers Connect

%3CLINGO-SUB%20id%3D%22lingo-sub-330187%22%20slang%3D%22en-US%22%3ESlicers%20Connect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330187%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20need%20your%20help%20with%20slicers.%20Is%20there%20anyway%20of%20connecting%20the%20pivot%20slicers%20with%20the%20source%20table.%20Ideally%20I%20would%20sort%20the%20Pivot%20and%20the%20table%20at%20the%20same%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-330187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-330219%22%20slang%3D%22en-US%22%3ERe%3A%20Slicers%20Connect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330219%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can't%20connect%20to%20both%2C%20you%20may%20filter%20source%20table%20and%20Pivot%20Table%20will%20work%20on%20filtered%20table%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-330215%22%20slang%3D%22en-US%22%3ERe%3A%20Slicers%20Connect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330215%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%20Tks%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20connect%20the%20table%20slicer%20with%20the%20pivots%2C%20but%20i%20cannot%20do%20it%2C%20how%20can%20I%20make%20that%20connection%20work%20and%20affect%20the%20pivots%20with%20the%20slicer%20created%20in%20the%20table%20source%3F%20Can%20you%20help%20me%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-330205%22%20slang%3D%22en-US%22%3ERe%3A%20Slicers%20Connect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330205%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20slicer%20your%20source%20table%20and%20that%20filter%20affects%20Pivot%20Table%20as%20well.%20Not%20in%20opposite%20direction.%3C%2FP%3E%3C%2FLINGO-BODY%3E
catiabd
New 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