Need help in summing the exception conditions

[ferha_jafri]

Hello Everyone,

I need help , in the scenario such as i need summation of actual and the condition is like dimension = channel , brand and if(channel =Key  and

customer type=CT3 then ( total customer name - CUS3 (Customet name), sum(Actual),

if(

channel =DOM  and

customer type=CT1 then  CUS3 (Customet name),SUM(Actual) else sum(Actual)  for rest of the channels.

Please reply it is urgent.