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
