For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mapping reference:
The issue I am having is that I am unable to properly map the formula. Resulting in various error messages.
I have been using variation of LOOKUP, and LOOKUP & SELECT functions, to no avail.
Looks like everyone has figured the correct SYS08 Product Family Lookup for this line, but recall that in a prior step we created DEM02 Volume Growth Rates by Week using formula 'MONTHVALUE('DEM01 Volume Growth Rates'.Growth %)' to bring the monthly value in DEM01 down to a weekly level.
My formula was successful when I accessed that weekly growth rate data.