title: Replacing an output in SSRS with another value
body: <p>I have a table with 2 columns, TutorInitials and TargetGrade. Where a user does not have a grade, we need to replace it with the grade given to a different user. e.g:</p>
  
  <pre><code>TutorInitials    TargetGrade
  1                A
  2                B
  3       
  4                C
  </code></pre>
  
  <p>TutorInitial 3 has no grade, so wherever they pop up in a report when showing 'TargetGrade' we need to replace the empty box with the 'TargetGrade' result for TutorInitial 2 ('B'), so it shows up like this:</p>
  
  <pre><code>TutorInitials    TargetGrade
  1                A
  2                B
  3                B
  4                C
  </code></pre>
  
  <p>Apologies if I have not explained it very well, I am very new to SSRS. </p>
  
  <p>I have tried using IIF and WHERE expressions but cannot get it to work.</p>
  
  <p>Thanks
  Rob</p>
  
  <p>Edit: What has happened is we have subjects at a school where the teacher has changed halfway through the year. The new teachers need to have a students target grade pulled through from the previous teacher. So rather than just grabbing the grade from the cell above, it needs to come from a specific tutor (the subjects first teacher), so I might need to replace the grade with the grade for 1,2 or 4.</p>