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

Copper 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!

0 Replies