title: SSRS Alternating Row Colors Within Groups
body: <p>I have some issues getting alternate row colors.</p>
  
  <p>I've tried different expressions and this is as close as I've gotten to getting it done:</p>
  
  <pre><code>=IIF(RunningValue(Fields!agent_name.Value,CountDistinct, Nothing) MOD 2 = 1, "Gainsboro", "White")
  </code></pre>
  
  <p>Where all other of my reports are getting correct alt row shading, I'm having trouble with this specific report that has a Row group and a Column group.. Spent about 2 days and still no luck :(  </p>
  
  <p>When I make my rows with the above expression, it is displayed like this:
  <a href="https://i.stack.imgur.com/Z5XeG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z5XeG.png" alt="result showing using above expression"></a></p>
  
  <p>My Row group obviously is the name,</p>
  
  <p>Column group is the Month/year.</p>
  
  <p>Any suggestions / assistance would be greatly appreciated</p>