aggregate error?

[AJ]

I am getting the following error: "you tried to execute a query that
does not include the specified expression 'Y' as part of an aggregate
function. Any ideas?

select TOP 5 sum(x)
from tableA
order by y;

HELP!! Thanks.

 

[Allen Browne]

You didn't see the reply to your earlier post where you provided more info?

 

[AJ]

Thank you Allen.....that worked great!!