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
Bookmarks