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

%3CLINGO-SUB%20id%3D%22lingo-sub-503683%22%20slang%3D%22en-US%22%3ERe%3A%20Different%20sheets%20have%20the%20same%20pivottable%20with%20each%20time%20a%20different%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-503683%22%20slang%3D%22en-US%22%3EHi!%3CBR%20%2F%3EAlsompost%20this%20in%20the%20excel%20forum!%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-503639%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-503639%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CBR%20%2F%3EI%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.%3CBR%20%2F%3ENow%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.%3C%2FP%3E%3CP%3ECan%20anyone%20explain%20what%20I'm%20doing%20wrong%20and%20how%20I%20can%20solve%20this%20issue%3F%3C%2FP%3E%3CP%3ESee%20sheet%20n%C2%B011%20to%20start%20with%20Sheet%20person%20A%20%3D%20%22Arnault%22%2C%20person%20B%20%3D%20%22Brent%22%20etc%3CBR%20%2F%3EI%20thank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-503639%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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!

1 Reply
Highlighted
Hi!
Alsompost this in the excel forum!

Adam