select ROW_INDEX,DeptName,Qty,CurrentPercentage,sum(Qty)over(order by ROW_INDEX rows 3 preceding) as total,
round(convert(float,sum(Qty)over(order by ROW_INDEX rows 2 preceding)/(select sum(Qty) from #TB_INFO)),3)*100 as totalpercentage
from #TB_INFO group by ROW_INDEX,DeptName,Qty,CurrentPercentage