title: SUM of only TOP 10 rows
body: <p>I have a query where I am only selecting the TOP 10 rows, but I have a SUM function in there that is still taking the sum of all the rows (disregarding the TOP 10). How do I get the total of only the top 10 rows?
  Here is my SUM function :</p>
  
  <pre><code>SUM( fact.Purchase_Total_Amount) Total
  </code></pre>