Hello Experts ,
I just Want To Take Data from (Increment by Product family) to (increment By product) For this I used Lookup Function ex Increment by Product family[lookup: Product family] formula apply successfully but did not get any value . can u help me
Remember Product is the child of product family
Thanks in advance
Based on your screenshots, it looks like you are also moving from a time dimension of year to months. Due to this, you'll also need to do a lookup on time by doing a lookup of the year for each month. You will still need to do the product family lookup with this.2
Please use below formula.
Increment by Product family[lookup: Product family, Lookup: Months]
In your system time module there might be lookup from years to months, if not create one either in your system module or target module.