Can I use Lookup Formula in this case ?
I'm currently working with a model that provides weekly forecasts for all products. My goal is to obtain forecasts categorized by product type (S or W) instead. However, when I attempt to use a lookup, I encounter this error message : "Format of mapping used for lookup doesn't match any dimension of the source". Could you please assist me? I've attached a screenshot for reference.
Target model : Forecast of products W : dimension(Product list, Time Week)
Source model : Forcecast of all product : dimension(Product list, Time Week)
Maping : Product type
Product type is a line item
Error messages :