hi,
I'm having a query like

select case month(sanct_dt)<=3 then year(sanct_dt)-1 else year(sanct_dt) as CurFinYear, sum(ttl_amt) from sanctionTable

the basic idea is to get the financial year for the sanction date based on the month and total the amount grouped on CurFinYear.

I can't give CurFinYear in group by as it gives invalid col name error

how to group the above sql ??? any other way is possible ?

TIA