I have multiple customers who may purchase different products. I want to list all of my customers on the rows line and then the products on the row line with the Month of sale in the columns and the amount of sales in each cell. I am listing this all at text to export into excel. The problem I am having is that not every product is showing up for every customer, only the products that they have sales for are showing up. How do I get every product to show up for every customer, regardless if there is a null value?
What happens if you uncheck "Hide Empty Rows" from the Table main menu?