The Pivot Table is going to show all the data from the selected range. The items that are showing without any values are listed in your data set without any values.
A mindset for the Database, or any data set to reduce waste, is that only records with data are recorded. Those rows are incomplete and, for some, not appropriate to be included in the dataset.
Also, there is a difference between 0 (zero) and NULL (no records.)