title: Grand total for pivot table not giving me the correct amount when using a calculated field
body: <p>I have a pivot table that I put a calculated field in. the calculation is <code>=IF(fddue_date&lt;finspectData,0,COUNT(fLotSize))</code></p>
  
  <p>The problem is that instead of getting the expected result of 6 I get 1. Any one have an idea what I am doing wrong?</p>
  
  <pre><code>Row Labels  Count of fLotSize   Sum of Field1
  5/14/2014       
  5/12/2014   1                   0
  5/14/2014   7                   1
  5/15/2014   9                   1
  5/16/2014   5                   1
  5/19/2014   3                   1
  5/30/2014   1                   1
  6/9/2014    1                   1
  Grand Total 27                  1
  </code></pre>