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.