oracle query with max and group by clause

SELECT MAX(day_of_week) AS day_of_week,
         MAX(month) AS month,
         order_by,
         MAX(CASE WHEN rep_id = 2 THEN goals END) AS jen,
         MAX(CASE WHEN rep_id = 11 THEN goals END) AS sheri
    FROM wkly_proposed_goal_improve
GROUP BY order_by
ORDER BY order_by

Thanks for the solution

I also wanted the query to give me data from the present month that we are running the report.  For now from JUL onwards.

that's not what your expected results showed.

is month meaningful as a date criteria?

What about January of next year?  That's in the future, but January of last year is in the past.  How will comparing JAN to JUL help determine which is which?

I have the year in the table as of now it is for 2014. The user adds data to the table with year and corresponding goals

The below is the query that runs as a dbms_job every sunday night

 select distinct trunc(sysdate+1) as day_of_week,
                 YEAR,
                         a.REP_ID,
                         GOALS,
                         a. MONTH,
                         ORDER_BY,
                         GOALS*120/100 as booking_target,
                 booked_now, ( booked_now- (GOALS*120/100)) as booking_surplus_deficit
from  proposed_goal a , proposed_annual_goal b
 where a.rep_id = b.rep_id
   and a.month = b.month
   and booked_now is not null
 order by rep_id,order_by

So I will pull the report by adding the year.

thanks