How to show missing items in Pivot Table
22 November 2013
When you create a pivot table from your source data, it only shows the items that have data. For example, if you put Customers and Products in the Row area, it only lists the items that each customer has bought.
In this article we'll see how to show items with no data in some records, show zeros in empty cells, and show items that have no data at all.