10 Replies Latest reply: Oct 5, 2017 2:29 PM by Matthew McIlvride RSS

    Average of certain values in row of pivot table

    Matthew McIlvride

      I have a pivot table that looks something like this:

       

      Employee NameMonday
      Clock In TimeClock Out TimeTime Worked
      Arnold9:00 AM5:00 PM08:00

       

      It includes data for weekdays Monday - Friday. The data tab for my pivot table looks like this:

       

      Rows

      EmployeeName

       

      Columns

      DayOfWeek

       

      Measures

      ClockInTime

      ClockOutTime

      TimeWorked

       

      I would like for my pivot table to include a weekly average of time worked based on each day's TimeWorked value. How could I go about this?