title: SSRS ignore a row for total
body: <p>I built a report in SQL Server Reporting Services using a cube.</p>
  
  <p><a href="https://i.stack.imgur.com/hDFvz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hDFvz.png" alt="enter image description here"></a></p>
  
  <p>This report is grouped based on country names and as you can see in the report, the column Pennsylvania is built manually by summing (Philadelphia,Harrisburg and Pittsburgh). But, in the total, I don't want the Pennsylvania value included. I need the total like 378-82=296. What expression should I give to ignore Pennsylvania in the total?</p>