title: How to include filtered rows in a datawindow computed field for Sum (PowerBuilder)
body: <p>I have a datawindow that has 2 groups (Company and Department).  I need to show the overall total amount for the company even if the user has filtered by Department.<br>
  <strong>Data Scenario</strong>  </p>
  
  <pre><code>Company   Department Role       EmpCount
  ABC       X          Managers       2
  ABC       X          Employees     33
  ABC       Y          Managers       1
  ABC       Y          Employees      9
  </code></pre>
  
  <p>I need the group totals for the Department Group (Group 2) to include only the count for that department <em>(sum(EmpCount for group 2))</em> ... which works.<br>
  I need the group totals for the Company Group (Group 1) to include the count for ALL departments <em>(sum(EmpCount for group 1))</em> or <em>(sum(EmpCount for all))</em> whilch works initially.  </p>
  
  <p>But, when the user <strong>filters</strong> the datawindow to only show the rows for the "X" department, the group total for the Company group now only reflects the data for the one department (35) but <strong>I need it to always show for ALL (45)</strong>.<br>
  The datawindow is also editable so the value must be a computed field, not a retrieved value.</p>
  
  <p>I have tried using SetDetailHeight to 'hide' the rows for other departments, which works for keeping the Company group totals correct, but it still shows the trailer for the departments that are filtered out. </p>