Yodelayheewho
Member
Hello,
I have a pivot table that tracks ship dates. I do not want rows to appear on the pivot table unless there is a ship date. So, I set the column to exclude blanks. This works until I refresh the data. If a new order has shipped, it defaults to being unselected in the filter list (see image). Is there a better way to do this?
I appreciate your consideration.

I have a pivot table that tracks ship dates. I do not want rows to appear on the pivot table unless there is a ship date. So, I set the column to exclude blanks. This works until I refresh the data. If a new order has shipped, it defaults to being unselected in the filter list (see image). Is there a better way to do this?
I appreciate your consideration.
