Slicer for multiple data sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2277316%22%20slang%3D%22en-US%22%3ESlicer%20for%20multiple%20data%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277316%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20just%20use%20a%20single%20slicer%20for%20multiple%20data%20sheets%20from%20pivot%20tables.%20Attached%20is%20my%20workbook%20with%20multiple%20data%20sheet%20of%20rainfall.%20I%20want%20to%20create%20a%20slicer%20linking%20the%20data%20sheets.%20My%20slicer%20is%20to%20be%20year%20so%20that%20I%20can%20create%20monthly%20details%20for%20a%20particular%20year.%20The%20records%20for%20the%20yearly%20data%20varies%20with%20respect%20to%20different%20place(sheet).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2277316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2278803%22%20slang%3D%22en-US%22%3ERe%3A%20Slicer%20for%20multiple%20data%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278803%22%20slang%3D%22en-US%22%3EI%20realized%20that%20you%20join%20all%20the%203%20Data%20sheets%20into%20a%20single%20sheet.%20The%20out%20come%20is%20when%20you%20select%20a%20particular%20year%20%2C%20you%20have%20more%20than%20one%20result.%20Example%20if%20I%20select%201973%20%2C%20I%20get%20result%20for%201973%20from%20site%20A%20and%20also%20Site%20B.%20However%20I%20only%20want%20the%20result%20to%20be%20from%20a%20single%20site%20and%20not%20multiple%20sites.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277674%22%20slang%3D%22en-US%22%3ERe%3A%20Slicer%20for%20multiple%20data%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277674%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921906%22%20target%3D%22_blank%22%3E%40Liphor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20another%20%22Reinfall%22%20from%20me%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EZur%20Zeit%20kann%20ich%20mit%20nicht%20besseres%20Dienen.%26nbsp%3B%3C%2FP%3E%3CP%3ESry%20aber%20nicht%20die%20Zeit%20zur%20Verf%C3%BCgung%20die%20ich%20als%20Anf%C3%A4nger%20brauche%20um%20dies%20zu%20bewerkstelligen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20look%20the%20file%2C%20maybe%20is%20fit%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%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277570%22%20slang%3D%22en-US%22%3ERe%3A%20Slicer%20for%20multiple%20data%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277570%22%20slang%3D%22en-US%22%3EMy%20data%20sources%20are%20different%20even%20though%20they%20are%20of%20the%20same%20format.%20I%20have%20tried%20and%20is%20not%20able%20to%20connect%20them.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277400%22%20slang%3D%22en-US%22%3ERe%3A%20Slicer%20for%20multiple%20data%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921906%22%20target%3D%22_blank%22%3E%40Liphor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CH2%20id%3D%22toc-hId--493657448%22%20id%3D%22toc-hId--467919852%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F2352-excel-multiple-pivot-tables-same-filter.html%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EHow%20to%20apply%20the%20same%20filter%20to%20multiple%20pivot%20tables%3F%3C%2FA%3E%3C%2FH2%3E%3CP%3ESometimes%2C%20you%20may%20create%20several%20pivot%20tables%20based%20on%20the%20same%20data%20source%2C%20and%20now%20you%20filter%20one%20pivot%20table%20and%20want%20other%20pivot%20tables%20are%20filtered%20with%20the%20same%20way%20as%20well%2C%20that%20means%2C%20you%20want%20to%20change%20multiple%20pivot%20table%20filters%20at%20once%20in%20Excel.%20This%20article%2C%20I%20will%20talk%20about%20the%20usage%20of%20a%20view%20feature%20Slicer%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHope%20I%20could%20help%20you%20with%20this%20information.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Is it possible to just use a single slicer for multiple data sheets from pivot tables. Attached is my workbook with multiple data sheet of rainfall. I want to create a slicer linking the data sheets. My slicer is to be year so that I can create monthly details for a particular year. The records for the yearly data varies with respect to different place(sheet).

4 Replies

@Liphor 

How to apply the same filter to multiple pivot tables?

Sometimes, you may create several pivot tables based on the same data source, and now you filter one pivot table and want other pivot tables are filtered with the same way as well, that means, you want to change multiple pivot table filters at once in Excel. This article, I will talk about the usage of a view feature Slicer in Excel.

 

Hope I could help you with this information.

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

My data sources are different even though they are of the same format. I have tried and is not able to connect them.

@Liphor 

Here is another "Reinfall" from me

Zur Zeit kann ich mit nicht besseres Dienen. 

Sry aber nicht die Zeit zur Verfügung die ich als Anfänger brauche um dies zu bewerkstelligen.

 

Please look the file, maybe is fit

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

I realized that you join all the 3 Data sheets into a single sheet. The out come is when you select a particular year , you have more than one result. Example if I select 1973 , I get result for 1973 from site A and also Site B. However I only want the result to be from a single site and not multiple sites.