• 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