title: SSRS If Column X value = "X" then display corresponding column Y value
body: <p>I am using SSRS 2008 and have a dataset that looks like this: (simplified)</p>
  
  <pre><code>RESULTGUID    Question    ANSWER 
  1234          How Old     15
  1234          How New     13
  1234          How Big     700
  1234          How Small   100
  etc etc
  </code></pre>
  
  <p>I'm looking for an IIF statement like:</p>
  
  <pre><code>=iif(fields!Question.value = "How Old",Fields!Answer.value,"N/A")
  </code></pre>
  
  <p>However, this doesn't work apart from the first row, so if first(fields!  etc then works fine, but not for the rows lower down the data-set.</p>
  
  <p>Can anyone offer a solution to this please ?</p>