Add a calculated column in a Pivot Table

kaia2001

New member
Joined
Sep 5, 2018
Messages
9
Reaction score
0
Points
0
Excel Version(s)
Office Standard 2013
Ok Gurus!

Can this be done? I have a Pivot table that returns the number of orders an employee processes each hour. I want to add a column that will calculate the Unit per Hour each hour as the day progresses. For instance the day starts at 5am hour 1 is 5-6am so the first hour will be 10 orders/1 the second hour will be 15 orders/2 @ 7am , etc... Is this possible? I feel like I may be over complicating this, thus me bringing it to the forum. Thank you all in advance.
 
Back
Top