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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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?
 
Upvote 0

Forum statistics

Threads
1,214,322
Messages
6,118,888
Members
448,856
Latest member
Eduard_Stoo

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
Back
Top