Use a CASE expression instead of a WHERE clause.
select
Store,
sum(CASE WHEN SaleMonth <= 5 THEN PlannedSales END) as 'Planned Sales',
sum(PlannedSalesYear) as 'Planned Sales Year',
sum(ActualSales) as 'Actual Sales'
from #Sales
group by Store
drop table #Sales
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA