How can you get missing data to show up in your Excel pivot table, showing a count of zero? AlexJ encountered this problem recently, and sent me his solution, to share with you.

One problem with pivot tables is that you can't use them to report on data that is not there. What if [...]