I'm looking into an alternative version of this with a smaller selection of critical data.
My crosstab has 5 levels and was setup with calculations as you suggested. (1 status calculation, 5 calculations to count status 1, 5 calculations to count total rows and 1 calculation to get the % status1/total rows).
However, now I have made a month comparison with 12 groups (-01, -02, -03....-12) to group the previous 12 completed months. For readability and user friendliness I would like the comparison to be horisontal.
Is there a good way to solve this with horisontal comparison?
With vertical comparison my previous calculation works fine, but the readability and user friendliness is not good since I get 12 repetitions of the dimensions, 1 for each comparison group.
I tried to set up a Status calculation for the "-12" group in the comparison, this was done with formula "
if sum(d-1, 0, m1) >= -5 then 1 else 0"
Why does it says status "1) for all comparison groups from -01 to -11?
Do I need to make 12 status columns, 12x5 count "status 1" columns and 12x5 count "total rows" columns, and 1 "%" column? That will be like 133 columns.