Assuming that your Pivot table is not so big (7 days by 24 hours), you could just go with the count by hour for each day of the week and then create a similar static table either underneath of in a separate sheet.
The contents of the static table would be calculations for each hour and weekday intersection by dividing the total count for that combination by the total count for that day (or hour, depending on what average you want).
