See the sample report in Excel and note the White space for Categories 2 & 3 where no data is available.
Cells in a matrix I created are not always populated for every year and category combination (Year is the X axis Category is the Y axis)
when the query is run. Is there a way to populate missing matrix cells with zero and, most importantly, when calculating %'s
(of row and/or column) to prevent the "NaN" result of division by zero.
Right now I am populating a "zero table" in the SQL which seems like a hookie way of doing things.
Many thanks in advance.