title: SSRS Matrix using a Dynamic Column Header
body: <p>I have an SSRS Report with a Matrix that looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/mHO0U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mHO0U.png" alt="enter image description here"></a></p>
  
  <p>and will return this:</p>
  
  <p><a href="https://i.stack.imgur.com/wrJtw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wrJtw.png" alt="enter image description here"></a></p>
  
  <p>This Matrix currently give me exact pivot and values I need, but I need the column headers to be something different. In the same table I get the [Key] column from, I have another column called [ColumnHeader] that I would like to display instead.
  However the pivot will not work if I use the value of [ColumnHeader], hence why I only want to display the value but actually pivot using the [Key] value. </p>
  
  <p>The end result will display like this:</p>
  
  <p><a href="https://i.stack.imgur.com/APjyj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/APjyj.png" alt="enter image description here"></a></p>
  
  <p>and return this:</p>
  
  <p><a href="https://i.stack.imgur.com/og1bD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/og1bD.png" alt="enter image description here"></a></p>
  
  <p>But it will still display the same information from the first picture.
  Please note that [Key] and [ColumnName] are not the same value. [Key] is able to return the values I want while [ColumnName] are names of the columns I need to display.</p>