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