Copy pivot table and change filter

[kiwikiki718]

Hi I copied a Pivot table from sheet 1 to sheet 2. however when I change the filters on sheet 2 pivot table it also reflects the changes on the Pivot table for sheet 1. How can I make changes to sheet 2 pivot table without affecting sheet 1 pivot table?

Thanks in advance

 

[Alex Blakenburg]

That normally only happens if your pivot table has a slicer attached to it.

 

[kiwikiki718]

I see. just an u

Hi I copied a Pivot table from sheet 1 to sheet 2. however when I change the filters on sheet 2 pivot table it also reflects the changes on the Pivot table for sheet 1. How can I make changes to sheet 2 pivot table without affecting sheet 1 pivot table?

Thanks in advance

Thank you just an update to what I posted. Its actually a pivot chart that I am copying another sheet that once I make any updates to the copied Chart the changes also reflects on sheet 1 chart

 

[Alex Blakenburg]

What do you call "any" updates ? Are you referring to filtering or chart formatting ?
Are the charts based on a pivot table or did you go straight to it being a pivot chart ?
Did you load your data to the data model and is the chart based on that ?