title: Create weekly reports to show how many patients Nurse A, B and Provider A, B saw
body: <p>Below is an example of a dataset I have on which I need to report. I'm open to using either Excel or Access for this (currently, the dataset is in Excel format).</p>
  
  <p><a href="https://i.stack.imgur.com/wmw8W.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wmw8W.jpg" alt="enter image description here"></a></p>
  
  <p>I need to create weekly reports to show how many patients Nurse A, B and Provider A, B saw. Then, I need to give % of "Yes" for each variable.</p>
  
  <p>Ex. from 10/19-10/23, Nurse A saw 3 patients and was 66% complete in Var1, 66% complete in Var2, and 66% in Var3, etc.</p>
  
  <p>Can this be done in a PivotTable or something similar?</p>