title: calculated field in pivot table divide one column by the other EXCEL
body: <p>I have two columns in a pivot table. Count of Work orders, and Sum of the Cost.
  I want to insert a calculated field that simply divides the sum of cost by count of work orders to get an average per work order.</p>
  
  <p>When I put I insert a calculated field with the following formula, it yields the total cost, not the average. You'll see the fields are subtotal (cost) and WO#(work order)</p>
  
  <p><a href="https://i.stack.imgur.com/Gidqs.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Gidqs.png" alt="enter image description here"></a></p>
  
  <p>And here is what the output looks like in my pivot table.</p>
  
  <p><a href="https://i.stack.imgur.com/Y8BiL.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Y8BiL.png" alt="enter image description here"></a></p>