A pivot table is a great way to see a summary of sales to your customers. You can see how much they bought, and how much they spent, on each product.
But, by default, pivot tables don't show missing data. By making changes to the pivot table, you can easily spot the missing products for each customer:
- Option 1: Change the pivot table layout.
- Option 2: Show all items.
- Option 3: Show only the customers with no purchases.