Hi-Experts,
I Have a requirement for that I need your help.
Module name: Summery module
Dimension in the module - Time, Category, Product, customer
I wanna move to all products(except fruits) sales data to one customer(AR Channel).
Fruits data move to another channel(FR Channel).
IF ITEM(Customer) = Customer.AR Channel then Sales upload.Total ELSE IF ITEM(Customer) = Customer.FR Channel THEN Sales upload.Total[LOOKUP: PRODUCT. Fruits] ELSE 0
But this formula was not working. How to move to some sales data to one channel and another portion of data to another channel.
Please help me with this
Regards,
Mahesh