hi, all
i want to create a crosstab like below:
A B C D
A 1,000 null null null
B null 99.5 null null
C null null 99.85 null
D null null null 100
but actually i got the below:
A B C D
A 1,000 1,000 1,000 1,000
B 99.5 99.5 99.5 99.5
C 99.85 99.85 99.85 99.85
D 100 100 100 100
anyone can help me?thanks.
Edited by: Ada_Wei on Feb 22, 2011 10:03 AM