Pivot Table - Calculated Field

jms2553

Board Regular
Joined
Jun 5, 2002
Messages
107
I have a Pivot Table that provides me with total number of hours worked for each team. Each team has a different number of employees and each employee works a different number of hours...on several different occasions during the week. What I need to see is the average number of hours for each team, based on the number of employees and the hours they worked. For instance, in Team A, the total number of hours worked was 32.75 and there were 16 employees so I know the average is 2.05 hours but I would like my Pivot Table to show me that. I think I should be using a calculated field but so far, all my attempts have not been successful.

Right now, my Pivot Table lists the team names in Column A and the employee names are in Column B.

As always, any help is greatly appreciated!
 
Last edited:

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
37,365
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Not sure without seeing the data, but can you not simply right-click the hours field, choose field settings and change it from Sum to Average?
 

Forum statistics

Threads
1,141,730
Messages
5,708,143
Members
421,549
Latest member
Dtcfire

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top