title: SSRS Reporting error in Total
body: <p>I have Developed a new SSRS report. I added a new tablix in it and in that tablix added two columns called "Total Incidents logged" and "Total Security Incidents logged".I gave row visibility and mention the following expression.
  =iif(Fields!SecurtiyIncidents.Value = 0,true,false)</p>
  
  <p>So i hide those rows in which values of security Incidents contains 0. But the problem is, in total column of Total Incidents logged, it contains the hide values also. I googled and found only those answers which contains only one Column and people gave row visibility. But in my case there are 2 columns. </p>
  
  <p>For better understanding, i have added images. In first image, the normal table is there with total</p>
  
  <p>in second picture, given row filtration on Security Incidents Logged, i.e =iif(Fields!SecurtiyIncidents.Value = 0,true,false)(So i hide those rows in which values of security Incidents contains 0) but if you see total of Incidents logged, it not changed. :(</p>
  
  <p>Could anyone please help me out?  </p>
  
  <p><a href="https://i.stack.imgur.com/tJlWj.jpg" rel="nofollow"><img src="https://i.stack.imgur.com/tJlWj.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/lO31t.jpg" rel="nofollow"><img src="https://i.stack.imgur.com/lO31t.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/SzzwC.jpg" rel="nofollow"><img src="https://i.stack.imgur.com/SzzwC.jpg" alt="enter image description here"></a></p>