I have an XLS attached where I want to perform some additional calculations in the pivot table. The Data tab shows the data which is a 6 week history of tickets/calls over this period.
The Pivot Table sheet shows the pivot table I have created showing the number of tickets/calls received per hour for each day and week.
The calculations I want to perform are around averages. I want to add the following:
- Show average number of tickets per week by hour of the day with total average for week (ideally a summary row at the bottom of the pivot table)
- Show average number of tickets per same weekday (Mondays, Tuesdays etc) by hour of the day with total average for whole day (again a summary at the bottom)
An example is show in yellow at the bottom of the pivot table.
Can these calculations be shown in the same pivot table or do they need to be in a separate one?