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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies