3 Replies Latest reply on Feb 13, 2019 7:28 AM by Helen Rowson

    Show Data Items with no data

    Helen Rowson

      I note that there are similar posts with this issue however I haven't been able to replicate the solution as my SQL/script skills aren't too good.  In the attached workbook I have data for two organisations.  For one of the organisations there is no data
      for some of the tests however I still want them to display in the list on the left-hand side. You’ll see if I select Org 1, ‘barium enema’, ‘sleep studies’ and ‘urodynamics’ appear however if I select Org 2 it disappears because there is no data.  Any help would be appreciated.