5 Replies Latest reply on Jun 19, 2018 2:01 PM by Stephen Brown

# Multiple Dimensions on a single row

I am developing a report about patients with any of five diagnoses for sickle cell.  For each diagnosis, I have written a calculated field that places a space (' ') if null or 'yes' if the particular diagnosis is matched (d57.01, e.g.).  The result is five different rows for each diagnosis, but I would like to get it down to one row.  Below is the desired format.  Thanks!

Patient #        Encounter Number       Arrival Date          D57.00     D57.01    D57.211    D57.411    D57.811

12345            12345-8570                   1/1/2018                              YES                                           YES

• ###### 1. Re: Multiple Dimensions on a single row

You can put all f the fields on a single row. I guess I don't understand the question.

• ###### 2. Re: Multiple Dimensions on a single row

Hi Stephen,

Can you just drag those dimensions right into the rows shelf so that they're side by side? -

Unless I'm also misinterpreting the question...

Thanks,

Mavis

• ###### 3. Re: Multiple Dimensions on a single row

Mavis, Ken;

Here is an example.  The last four digits of the financial number indicate both rows are from the same encounter, and two sickle cell diagnoses were encoded during that particular patient visit, but the diagnoses are placed on separate lines.

• ###### 4. Re: Multiple Dimensions on a single row

Hi Stephen,

That's because you have ROW which splits it into two rows. If MRN-Organisation is different between the two rows then this will also split the rows up.

Please remove ROW and possible MRN-Organisation from the view if you want it as one row.

Thanks,

Mavis

• ###### 5. Re: Multiple Dimensions on a single row

Thanks Mavis;

I took the row out but its still inserting multiple rows.  I just wrote another report with similar formatting and it worked fine.  Will continue to debug.