How to get the nth occurrence of an item using the same list
Hope you can help me with this requirement, this is the scenario: there is a list of products and a dedicated module that allows the user to select the replacement product from the same list.
A product can be replaced by one product only, while any product can replace multiple existing products.
Referring to the attached image, do you know how to populate the module on the right? Specifically, I would like Anaplan to return which substituting products replace the related existing products, based on the first module on the left (1st occurrence, 2nd occurrence, nth occurrence, etc.). This module is dimensioned by an additional list of 'n' items (Generic Products).
Would it be feasible to get this result through some calculations and additional line items? Do you suggest any other method?