You could get this done with a derived table:

SELECT
 CurFinYear,
 SUM(ttl_amt)
FROM (
 SELECT 
  case month(sanct_dt)<=3 then year(sanct_dt)-1 else year(sanct_dt) as CurFinYear,
  ttl_amt
 FROM
  sanctionTable) AS x
GROUP BY
 CurFinYear

-Mike


>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