title: Properly Aggregate datas in RDLC
body: <p>I have this Data from the DataSet which I then display in the tablix on an rdlc report viewer. This datas have redundant <code>CUSTOMER NM</code>(which is group by 2's) that is why I want it to be blank display on the 2nd display.</p>
  
  <p>I am using this expression to hide the even rows that are displayed in the tablix which is under the column of <code>CUSTOMER NM</code>:</p>
  
  <pre><code>=IIF(RunningValue(Fields!CUSTOM_NM.Value,CountDistinct,Nothing) Mod 2, Fields!CUSTOM_NM.Value, "")
  </code></pre>
  
  <p>But the result is not what I am expecting.
  As you can see on the image below, it seems that the data's are being grouped as per same <code>CUSTOM NM</code>. and the <code>CUSTOM NM</code> that is set to <code>""</code> are the next same rows of <code>CUSTOM NM</code>. I color the groups so you can see them properly.</p>
  
  <p><a href="https://i.stack.imgur.com/inZoW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/inZoW.png" alt="enter image description here"></a></p>
  
  <p>My expected result would look like this image below</p>
  
  <p><a href="https://i.stack.imgur.com/7hvUh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7hvUh.png" alt="enter image description here"></a></p>
  
  <p>Anyone knows where I am doing wrong or miss something. Any help would be appreciated..</p>