Dear Friend,
Try this:-
Select GroupID,SUM(CreditAllowed) [Sub Total],T.[Grand Total]
from Customer
Outer apply
(
Select SUM(CreditAllowed) [Grand Total] from Customer
) T
group by GroupID,T.[Grand Total]
If it solves your purpose then mark this at your answer.
Regards
Varun