title: SSRS/SQL Report Conundrum - If X and Y, Mark intersecting cell Z
body: <p>I have never seen this question posed... I need to create a report where the X axis is a condition and the Y axis is an item. If an Item meets a condition, I need an "X" in the intersecting cell.</p>
  
  <p>Example :</p>
  
  <pre><code>         Frog      Sky      Lollipop
  
  Red        X                   X
  Blue       X        X          X
  Green      X
  </code></pre>
  
  <p>With that example, more specifically I need to show, in that format, Security groups across the top and functions down the side. The "X" would indicate which group would have which functions.</p>
  
  <p>Any ideas are appreciated.</p>