Hi
I have a list of the viewing figures of over 10,000 episodes of a soap opera that began airing in the 1960s.
Column A lists the date of an episode’s broadcast and column B lists the number of people who watched a particular episode.
The regular scheduling and number of weekly episodes has varied throughout the show’s run.
I want to find the highest rated episode from each calendar month without manually checking each month myself. Is there away to automate this?
Propably:
⇒Data⇒Pivottable⇒create…
drag&drop »Date« into Rowfield
drag&drop »number« into DataField
⇒ok
in the Pivottable Output click on some Date and ⇒Data⇒Group and Outline⇒Group:[x]Years [x]Month
This worked. I had to double click “viewing figures” and select “Max” on the data field and now it is displaying only the highest ranked ratings for a particular month.
I’m wondering now if it’s possible to make it display the date that the top ratings are associated with in the adjacent cell?