View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Sweeney John Sweeney is offline
external usenet poster
 
Posts: 1
Default Pivot Table Field based on two data area fields

How do I created a calculated field in a pivot table based on two data area
fields. My pivot table has three fields:
Username
COUNT Number of Items
SUM Hours to Complete

I want to add the field AVERAGE TIME TO COMPLETE that is calculated as
=SUM Hours to Complete / COUNT Number of Items