Slicers for pivot table and corresponding source table

%3CLINGO-SUB%20id%3D%22lingo-sub-1549516%22%20slang%3D%22de-DE%22%3ESlicers%20for%20pivot%20table%20and%20corresponding%20source%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549516%22%20slang%3D%22de-DE%22%3E%3CP%3EDear%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20several%20pivot%20tables%20that%20refer%20to%20the%20corresponding%20source.%3C%2FP%3E%3CP%3EAdditionally%2C%20I%20have%20inserted%20slicers%20to%20easily%20filter%20my%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20now%20figured%20out%20that%20the%20slicers%20only%20change%2Ffilter%20the%20data%20in%20the%20pivot%20table.%3C%2FP%3E%3CP%3EI%20want%20the%20slicers%20also%20to%20set%20the%20corresponding%20filters%20in%20my%20source%20table%20as%20I%20do%20want%20to%20use%20this%20filter%20function%20for%20additional%20analysis%20out%20of%20the%20source%20table%20that%20do%20not%20work%20via%20pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%26nbsp%3B%20On%20the%20I%20clear%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3ET%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1549516%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Dear community,

 

I have created several pivot tables that refer to the corresponding source.

Additionally, I have inserted slicers to easily filter my data.

 

I now figured out that the slicers only change/filter the data in the pivot table.

I want the slicers also to set the corresponding filters in my source table as I do want to use this filter function for additional analysis out of the source table that do not work via pivot table.

 

Is this possible?  Am I clear?

 

Thanks!

T

0 Replies