I have a cross tab....
Columns A, B, C
Rows X, Y, Z with a value in each
Data something like....
A  X  10
A  Y  11
A  Z  12
B  X   1
B  Y   2
B  Z   3
C  X   100
C  Z   200
Notice that for column C, there is no value for row Y.  Actually, this row does not exist in the data.
However, the cross tab is defaulting (i think) and showing this value as 0.00.
I want to be able to display something like a dash or NA for rows which do not exist.
So my cross tab would look some thing like this..
     A     B     C
X   10    1      100
Y   1     2      --
Z   100   3      200
Is this possible and if so, how can I do that?

Thanks

The problem with that is that there might be a row set as zero.  Which is valid.

I don't ant it to display zeros for rows which aren't actually there.

Regards

DC