Home

Different sheets have the same pivotgraph with each time a different filter

%3CLINGO-SUB%20id%3D%22lingo-sub-503765%22%20slang%3D%22en-US%22%3EDifferent%20sheets%20have%20the%20same%20pivotgraph%20with%20each%20time%20a%20different%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-503765%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20have%20different%20sheets%20which%20have%20always%20the%20same%20pivotgraph%20with%20a%20filter%20of%20%22Persons%22.%20Each%20sheet%20shows%20the%20data%20of%20each%20person%20by%20adapting%20the%20filter.%20Now%2C%20when%20the%20first%20Sheet%20with%20the%20pivotgraph%20is%20set%20on%20Filter%20Persons%20%3D%20%22Person%20A%22%2C%20sheet%20%22Person%20B%22%20has%20a%20pivotgraph%20also%20set%20on%20%22Person%20A%22.%20When%20I%20adapte%20this%20filter%20in%20sheet%20%22Person%20B%22%20to%20Filter%20Persons%20%3D%20%22Person%20B%22%2C%20the%20pivotgraph%20of%20sheet%20%22Person%20A%22%20is%20set%20to%20%22Person%20B%22.%20I%20can't%20set%20each%20sheet%20to%20every%20person%20in%20my%20list%20without%20the%20changement%20in%20the%20other%20pivotgraphs.%20Can%20anyone%20explain%20what%20I'm%20doing%20wrong%20and%20how%20I%20can%20solve%20this%20issue%3F%20See%20sheet%20n%C2%B011%20to%20start%20with%20Sheet%20person%20A%20%3D%20%22Arnault%22%2C%20person%20B%20%3D%20%22Brent%22%20etc%20I%20thank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-503765%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Redca1981
New Contributor

Hi I have different sheets which have always the same pivotgraph with a filter of "Persons". Each sheet shows the data of each person by adapting the filter. Now, when the first Sheet with the pivotgraph is set on Filter Persons = "Person A", sheet "Person B" has a pivotgraph also set on "Person A". When I adapte this filter in sheet "Person B" to Filter Persons = "Person B", the pivotgraph of sheet "Person A" is set to "Person B". I can't set each sheet to every person in my list without the changement in the other pivotgraphs. Can anyone explain what I'm doing wrong and how I can solve this issue? See sheet n°11 to start with Sheet person A = "Arnault", person B = "Brent" etc I thank you for your help!

Related Conversations