How to get Sum of Group in last row of group in SQL SERVER : Here is Example.

ID  Prod  --- Price <br>
01  Vios     --- 150<br>
01  Vios      ----120<br>
02  Copax     --100<br>
02  Copax     --200<br>

Desire Result should be 

ID   Prod   ---Price  Total<br>
01  Vios   -- 150  --  0<br>
01  Vios --     120 --   270<br>
02  Copax     100    ---0<br>
02  Copax     200    ---300<br>
