Help! I need information to calculate the average time spent by person on a task. To do so, I need a sum of the time spent by that individual / count of items they were assigned. I did the calculation to the right of the table manually, but if I refresh the data, the formulas don't follow and require manual copying etc. Is there a way to add a formula which takes the sum/count directly in the pivot table calculation?? See partial table below (I took a marker to delete the person and specific task information for privacy and security reasons):