J
John Sweeney
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
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