I have set up a crosstabs to display summarized monthly totals in my report. The problem is, some groups have no data for some months, and therefore the crosstabs are a different size than the rest (only show july-oct rather than jan-oct). Is there any way to force the crosstab to show the months that have no data? I have a formula outside the crosstab to do a ratio calculation for each month that is not possible in the crosstab and it needs to be aligned properly with the crosstab on all the groups.
If it is not possible to force the crosstab to do that, then is there any way to divide a summarized field in the crosstab by another summarized field in the crosstab? I have tried just making a formula, but what I think it is doing is on each record it will divide one field by another, and if either of the fields is zero, the result is zero. Any help would be appreciated, thanks.
If it is not possible to force the crosstab to do that, then is there any way to divide a summarized field in the crosstab by another summarized field in the crosstab? I have tried just making a formula, but what I think it is doing is on each record it will divide one field by another, and if either of the fields is zero, the result is zero. Any help would be appreciated, thanks.