still running into issues here. So if I leave the MAX function infront of my Case statement which contains the sum function for the values I need to total up my revenue, I receive the error

"Cannot perform an aggregate function on an expression containing an aggregate or a subquery."

If I remove the sum function from the case statement, I am able to run the query, but the output is still appearing on separate rows.

Am I missing something else?