I think you might be able to get by with a derived table...i.e put in the aggregate function in the derived table and join it up with the original query....

this link : http://qa.sqlservercentral.com/columnists/nboyle/speed_select.asp

gives examples of how to use derived tables..