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
>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.