CODEWITHSUNDEEP
excelpivot-table
zkvvoob
zkvvoob

Reputation: 486

Average total duration per day in Excel Pivot table with subtotals

I've got data for duration of calls for a number of days. I've created a Pivot table that groups dates by week number and right now shows subtotal SUM OF DURATION, i.e. the total time for the whole week.

However, I would like the weekly subtotal to show the average daily duration (e.g. day 1 - 3h, day 2 - 5h, average - 4h).

enter image description here

Is this possible?

Thank you!

Upvotes: 0

Views: 590

Answers (1)

Chris Harper
Chris Harper

Reputation: 213

In Pivot Table, Goto Values / Value Field Settings and then choose Average instead of Sum.

Upvotes: 0

Related Questions