Crosstable

[#1]

Hello All,

I need distinct values displayed in a crosstable. Here is my script-

CrossTable(Acct#, Diagnosis)
LOAD Distinct  
[ENCTR ID],
[PRIN DIAG],
[SEC DIAG & NAME]
Resident 20112012;

Here is whats displayed. If I just have 1 Prin Diag code for an acct it works fine and it only counts it once but thats not how it is displayed. I only want to see the record in red.

ENCTR ID	PRIN DIAG	SEC DIAG	All DIAG
WHX0005000	250.80 DMIL OT…	584.6 END STAG..	789.00 ABDMNAL
WHX0005001	250.80 DMIL OT…	783.1 NAUSEA	789.00 ABDMNAL
WHX0005002	250.80 DMIL OT…	789.00 ABDMNAL	789.00 ABDMNAL
WHX0005003	250.80 DMIL OT…	790.8 ABN SERU…	789.00 ABDMNAL

Thanks for the help,

EK