I have a set of sales transaction data which will be updated everyday, then I need to based on the sales data to update a PivotTable for Sales by different channel.

However, I need to exclude some sales data (which is "0" in sales price, it is free goods) first, so I creat a filter by the field name "Sales Price" in the pivottable

Problem I met:

I need to select all in the filter then un-select "0" everytime when there udpates in Sales data

Is there any way to automate this ? Do I need to do it by Macro?

Thanks

Jacky