Pivot table change when I filter data source

[HSOLDO]

Hi,

My last post had a mistake. When I keep pivot and data source on same sheet I need that Pivot doesnt change when I use filter on data source.
So in this case I need that when I use filter, that pivot allways stay the same (something like "stay on top") so it doesn get affected by hidden rows,

Thanks

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ge-when-i-filter-data-source.html#post5098544

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).