title: Excel Pivot Table - Averaging by Category
body: <p>I'm trying to create an average by category in a pivot table. This is the first time I've created a pivot table so sorry if the answer is staring me in the face. My raw data looks like:</p>
  
  <pre><code>Date,   Transaction type,   Description,     Paid out,   Paid in,    Balance,   Category
  Mar-13, Visa,   SHOP,    £4.44, ,        £X,    Gifts
  Mar-13, Visa,   SHOP,    £5.00, ,        £Y,    Children
  Mar-13, Visa,   SHOP,    £6.00, ,        £Z,    Gifts
  Mar-13, Visa,   CLOTHES SHOP YORK,   £8.00, ,        £A,    Clothing
  Mar-13, Visa,   FOOD SHOP,   £11.96, ,       £B,    Food
  </code></pre>
  
  <p>My pivot table shows the information rolled up by Month and grouped by a category:</p>
  
  <pre><code>Row Labels  Sum of Paid out Sum of Paid in  Sum of Difference
  2013            
     Jan        £Jan       £Jan                  £C
       Food       1              2                 -
       Car        2              3                     -
       Cash       6              6
     Feb         £Feb       £Feb                 £D
       Food       1              2
       Car        8              0
       Cash       2              3
  </code></pre>
  
  <p>The categories/data is made up in this case, but the desired outcome I'm after is to get an annual average, informing me how much comes in/out on average across the year per category... looking something like:</p>
  
  <pre><code>Row Labels  Sum of Paid out Sum of Paid in  Sum of Difference
  2013
     Avg        £AvgIn     £AvgOut              £AvgDiff    
       Food       1              2                 -
       Car        5              1.5               -
       Cash       4              4.5        
     Jan        £Jan       £Jan                  £C
       Food       1              2                 -
       Car        2              3                 -
       Cash       6              6
     Feb         £Feb       £Feb                 £D
       Food       1              2
       Car        8              0
       Cash       2              3
  </code></pre>
  
  <p>Is this possible to achieve using a pivot table, as I can't seem to find a way to this at the moment using Excel 2010.</p>