if an item is not ordered in a particular month, there is no record for it in the Orders table. For products ordered in the past, need to show a blank or a zero when the product was not ordered in a particular month. Don't want to show all products if they were never ordered.
Thank you for your response. The matrix you circled is fine if left unfiltered. My issue is when you filter down to Mary Jones, the matrix only shows her Feb 2020 bike order. I also need to also show Jan and March as either blanks or zero for bikes ordered . That is where I am having difficulty. Right not, it is confusing for our Customer Service Dept when they are looking up a customer. They need to see every month in the timeframe they are looking up if a product was ordered or not. Hope that makes sense.