title: Custom Formula for Grand Total column
body: <p>I have a frequent problem where the formula I want to use in the Values area in my Pivot-Table is different than the formula I want to use for the Grand Total column of that row. I typically want to Sum the Values but I want to average the Sums. Here is what I normally would get if I pivoted the dates on the Column Labels, Meat Type on the Row Labels, and Sum Orders in the Values. </p>
  
  <pre><code>Row Lables | Day 1 | Day 2 | Day 3 | Grand Total
  ________________________________________________
  Beef       |  100  |  105  |  102  |   307
  Chicken    |  200  |  201  |  202  |   603
  </code></pre>
  
  <p>I get sums by day and a sum of all of the days in the Grand Total column. Here is what I want to have:</p>
  
  <pre><code>Row Lables | Day 1 | Day 2 | Day 3 | Grand Total (Avg of Day Totals)
  ________________________________________________
  Beef       |  100  |  105  |  102  |   102.3
  Chicken    |  200  |  201  |  202  |   201.0
  </code></pre>
  
  <p>In this case the Orders are still summed by day but the Grand Total is now an average of the sums. What I do now is copy and paste the Pivot data onto a seperate sheet then calculate the averages. If there was a way to do this with a custom Grand Total column it would be incredible. This is one of the biggest shortcomings of Pivot Tables for me but I'm hoping it is due to my ignorance, which it often is. Thanks for the help!</p>