I created a table using the wizard and i sum the Duty Saved column for each month in the column groups. Everything works fine.
Now i need to Filter the matrix using the TABLIX Properties to sum only the rows where Version Reason = 'PSC'. but some months don't have a PSC, so i am not getting a placeholder cell in the output with a 0 in it.
I had no PSCs in Jan, Sept or Dec, 2018, so i am getting 9 cells, all shifted to the left.
How do i account for the possibility of a NULL value on a Tablix property filter?
THanks
I hope i provided enough info.