title: In SQL Reporting Services, is it possible to retrieve a certain value from a dataset, depending on values of multiple other columns in the same row?
body: <p>In SQL Reporting Services, is it possible to retrieve a certain value from a dataset, depending on values of <strong>multiple</strong> other columns in the same row?</p>
  
  <p>So, if this was my dataset:</p>
  
  <pre><code>Id    | Name      | Number | Score
  1     | "John"    | 16     | 22
  2     | "Jane"    | 64     | 24
  3     | "John"    | 20     | 18
  </code></pre>
  
  <p>I would like to have some sort of 'where' clause, so I can retrieve all/the value(s) where <code>Name == 'John'</code> and <code>Number == 16</code> for example. This would then return <code>22</code>.</p>
  
  <p>I've tried LookUpSet, but that will only compare one other column value. I need to compare two.</p>