Keep filter on pivot table when adding new data

Hi chaps,

I've got a pivot table with data in and I want to exclude zero result movements, but when i add new data with a new number of movements, for example if i added a location with 40 movements, when i refresh the pivot table that 40 is unticked in the filter... how can i make it so everything remains ticked except the zero?

Cheers,

I'm an idiot, just figured it out. I'll use the pivot value filter instead. thanks, byeeee