FYI - I managed to work out how to get the info I need when I have an odd number of records (field names differ from original example).  I used...

Chris,

As you suggested, I just did some experimenting with the "OVER" clause.  I partitioned by BookingMonth, OperatingUnit, and BookingSource, calculating AVG, COUNT, MIN, and MAX.  How is that different from...