• I don't have experience using crosstabs, but shouldn't the results in your example be:

    TYPE RED BLUE GREEN

    A 2 0 0

    B 1 0 0

    C 0 1 0

    D 0 0 1