MeowserM
asked on
Pivot Table filter - show ALL filtered items
Hello:
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.
Thank you
PivotTableExample.xlsx
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.
Thank you
PivotTableExample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome :-)
ASKER