title: Correct Grand Total in Pivot Using Calculated Field
body: <p>I have an excel pivot table which looks like</p>
  
  <pre><code>Date        Sum of DURATION   Capped Daily Total
  03-Jan                  9.5                  8.0
  04-Jan                  6.0                  6.0
  05-Jan                 10.5                  8.0
  06-Jan                  4.5                  4.5
  Grand Total            30.5                  8.0
  </code></pre>
  
  <p>As you can see, the Grand Total for Capped Daily Total is incorrect.
  In this example:</p>
  
  <ol>
  <li><code>Date</code> column is added as a Row and comes from source data. It has been Grouped By: Days</li>
  <li><code>Sum of DURATION</code> is added in the Values section and comes from the source data.</li>
  <li><code>Capped Daily Total</code> is a <em>computed field</em>. The formula used is <code>= MIN('DURATION', 8)</code></li>
  </ol>
  
  <p>When calculating the grand total it appears that excel has computed the Grand Total and then used the formula <code>= MIN('DURATION (HOURS)', 8)</code> to cap it to 8 hours. I don't want the formula to apply to the Grand Total - only to the rows. The grand total should be a simple <code>SUM</code> formula.</p>
  
  <p>How can I achieve this requirement in Excel?</p>