Hi all,
I am having an issue on pivot table here:
I am trying to create a numbers of pivot table with a numbers of sheet which i would like to display each every sheet with a different filter resulting graph with the same source of datas. The problem is, if i am changing the filter value-X of Sheet A it will automatically changing the filter of sheet B,Sheet C .....to the filter of X too. Any setting that i could stop it from automatically update the not intentionally sheets?
thank you
I am having an issue on pivot table here:
I am trying to create a numbers of pivot table with a numbers of sheet which i would like to display each every sheet with a different filter resulting graph with the same source of datas. The problem is, if i am changing the filter value-X of Sheet A it will automatically changing the filter of sheet B,Sheet C .....to the filter of X too. Any setting that i could stop it from automatically update the not intentionally sheets?
thank you