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

    Multiple Dimensions on a single row

    Stephen Brown

      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