title: Crystal Reports WHERE clause
body: <p>In Crystal Reports I want to write a formula that goes something like this</p>
  
  <pre><code>SUM(Sales) WHERE Department = 'Food'
  </code></pre>
  
  <p>How should I write this query in Crystal Reports?
  <br>I want this formula on a sub-report. I am aware that the <code>WHERE</code> clause is not usable in CR.</p>