select case when month(sanct_dt)<=3 then year(sanct_dt)-1 else year(sanct_dt) END as CurFinYear, sum(ttl_amt) from sanctionTable GROUP BY case when month(sanct_dt)<=3 then year(sanct_dt)-1 else year(sanct_dt) ENDOr you can use a derived table
SELECT st.CurFinYear, SUM(st.ttl_amt) FROM (SELECT case when month(sanct_dt)<=3 then year(sanct_dt)-1 else year(sanct_dt) END as CurFinYear, ttl_amt from sanctionTable) ST GROUP BY st.CurFinYear ORDER BY st.CurFinYear>hi,
>select case when 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.