title: Excel pivot table - average of calculated sums
body: <p>I'm sure this is simple, but how do I get a pivot table to display an average for a calculated sum of fields?  In the simplified example, I've filtered out fund x1, and the pivot table is showing the sums of the remaining funds per person.  Now how do I get an average <em>by person</em> (so, manually calculated, 3300/3)?  </p>
  
  <p>I tried using a calculated field, but cannot figure out how it will work because the denominator will change based on how many people will have the funds I'm filtering on. If I use the averaging inside the calculated field it goes back to averaging the funds.  </p>
  
  <p>I tried putting the calculation outside the pivot table, and this works, but of course as I filter, my calculated field is no longer adjacent to the pivot table data, instead just floating off on the worksheet by itself. </p>
  
  <p>TIA.</p>
  
  <p><img src="https://i.stack.imgur.com/MZCEL.jpg" alt="example"></p>
  
  <p>Per request here is the field list - if I try adding an "average of amount" to the value box it averages the fund amounts, instead of the fund amount per person. :</p>
  
  <p><img src="https://i.stack.imgur.com/Pp677.jpg" alt="enter image description here"></p>