I have a PowerPivot Table in Excel 2013 for reporting TV audience data.
I’m kind of stuck on one report that shows the viewership levels by Channel by hour by Day of Week.
The problem is that I want to show the total of viewership of all hours (Vertical Total) per day, and then have an average of viewership across days.
Please refer to the attached Excel sheet for an exact explanation of what I’m trying to do.
Thanks in advance for your usual support.