How to use SUMX and Groupby only on some fields and exclude the groupby on other fields of same calc

[sana_22]

I need to add the esxception amounts of all loan officers per category 

then get a ratio ( divide ) with the total comm from Core banking system 

[ryan_mayu]

pls provide the sample data and expected output