I have a simple spreadsheet with a simple pivot table. It has names and sales order numbers. The pivot table has the names as rows and the count of sales order numbers. I only want to see a couple of the names so I have a filter on the names and only checkmark the one's I want to see. This all works fine.
Each day I "copy in" new data and the pivot table works fine except for when one of the filtered names doesn't have any sales orders for that day. It doesn't show their name. In this situation I would like to have their name shown in the list but with a 0 count.
Is there a way to accomplish this?
I am going to attach a small example. Sheet 2 titled next day shows my problem.