I have 2 crosstabs that read from 2 different columns in my database. the values in the columns range from 0 to 5 however are not always present. I need for the column headers to always be 0,1,2,3,4,5 even if there are no 0's or 3's etc in that column so that the 2 crosstabs will always line up.
my crosstab shows the % of the total count that the 0-5 is in that column, so if there are no 0's i need to show 0% in the 0 column. Currently the crosstab only shows the columns that there are values for.
So how can I set a static number of columns for 0-5?