title: Finding ssrs matrix table coloumn values
body: <p>I have a SSRS matrix table, which generates column dynamically. but i want to add some static coloumn in that report(added manually). but the static columns will have the same value as one of the dynamic column. All i want to do is, find the specific dynamic column (a column name with DynamicColoumn1) and show it in this static column</p>
  
  <pre><code>=IIF(Fields!DynamicColumnData.Value = "DynamicColoumn1",Fields!DynamicColumnDataValue.Value, "")
  </code></pre>
  
  <p>this works only for the first data in the DynamicColumnData, not working for other values in the DynamicColumnData. Anyone faced similar problem?</p>