Love Mr. B!! Would not be where I am without his books!! Thanks to SQLServerCentral for doing the right thing....

SELECT Risk_Mit, sciClientID, Amt

,SUM(Amt) OVER(PARTITION...