title: SSRS - Extract value from a column from a dataset based on condition from 2 other columns
body: <p>I have 3 columns (category, Month, Amount) in my dataset, with values similar to these below:</p>
  
  <pre><code>Category   Month   Amount
  A          Jan       20
  A          Feb       25
  A          Mar       10
  R          Jan       15
  R          Feb       50
  R          Mar       55
  </code></pre>
  
  <p>On the report I need:</p>
  
  <pre><code>    Jan   Feb   Mar
  A   20    25    10
  R   15    50    55
  </code></pre>
  
  <p>I have tried placing this expression in each group row column, for example, in the Jan column it would be:  </p>
  
  <pre><code>=IIF(Fields!Category.Value = "A" and Fields!Month.Value = "Jan", Fields!Amount.Value, 0)
  </code></pre>
  
  <p>But I get the result <code>0</code>, like false result. </p>
  
  <p>Could you please let me know how to solve this problem.</p>