title: Calculated field totals not correct in PowerPivot
body: <p>I have a basic data set with a ton of slicers that roughly looks like this:</p>
  
  <pre><code>       Hours    SpreadPerHr      Spread
         5.00        5.00          25.00
         10.00       2.00          20.00
         8.00       10.00          80.00
  </code></pre>
  
  <p>Where Spread is a calculated value where Spread = Hours*SpreadPerHour. The problem is, the totals for these columns follow this formula too, so it looks like this:</p>
  
  <pre><code>       Hours    SpreadPerHr      Spread
         5.00        5.00          25.00
         10.00       2.00          20.00
         8.00       10.00          80.00
  Total: 23.00      17.00         391.00
  </code></pre>
  
  <p>And while the hours total up just fine, SpreadPerHour is dynamic and so Spread is as well. It is incorrect to say Total Spread = Total Hours * Total SpreadPerHour. Totals should be:</p>
  
  <pre><code>Total: 23.00      17.00         125.00 
  </code></pre>
  
  <p>Is there a way I can make excel leave totals for Hours as-is, but sum the column for Spread instead of multiplying totals? </p>