2 Replies Latest reply on Aug 16, 2018 9:42 AM by meenu choudhary

    Help with filters/display - showing incorrect numbers

    Jenna Gravley

      Hello all,

       

      I am working with data from several clinical trials. The number of participants enrolled are separated by clinical research site, protocol, and period of enrollment. My issue is that I just want to display the total number enrolled per site per period of enrollment. However, when I try to remove the protocol from the sheet the numbers are incorrect. See below screen shots and attached workbook (see "Enrollment" sheet).

       

      Separated by protocol, notice the total number of enrolled for the 2017_2018 period is 92:

       

      If I removed the protocol, the total number of enrolled for the 2017_2018 period shows incorrectly as 31:

       

       

      Thanks so much, any help is greatly appreciated!!!!

       

      Jenna