title: Calculating Weekly Average by user given daily data input in excel pivot table
body: <p>So I started using Pivot Tables a few weeks ago, but I'm pretty decent at Excel otherwise. I hit an issue that should be an easy fix and I don't see it. I have a document that is tracking Key Performance Indicators for my warehouse packing department. I have 2 tabs in the document that matter (Input Log, and Analysis).</p>
  
  <p>Input log is basically copied from a report generated from my warehouse system. Gives me a USER, DATE, HRS WORKED, ORDERS PACKED, ITEMS PACKED. Using a pivot table I want to see the average hours worked by week for each user. </p>
  
  <p>Currently I can only see the Sum of the hours works and the daily average. How do I also see the weekly average?</p>
  
  <p><a href="https://i.stack.imgur.com/FQEJa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FQEJa.png" alt="pivotTable"></a></p>
  
  <p>[InputLogData][2]</p>
  
  <p>I was able to get the workbook hosted on google drive <a href="https://drive.google.com/file/d/0BxQ8qCDNrIw1YzZXNXg1UHB2SUU/view?usp=sharing" rel="nofollow noreferrer">Packing KPI Workbook</a></p>