Returning Dimension/List Item based on Line Item
I'm trying to understand whether I can return a Dimension/List item when referencing a Line item rather than the Line Item result itself
I have 2 modules. 1st module is dimensionalised by FX Rates (columns) & Regions (List Formatted Line Item)
The 2nd module has a Line Item which is List Formatted with FX rates & dimensionalised by Regions.
I want to be able to return the FX Rate for the each region dimension. I thought FINDITEM(FX Rates,FX Mapping.'Region (Text)') but this doesn't work as I need to return the List item from the Line item, not the line item result itself
I am aware it is easier to build the FX rates module with Regions as a dimension and then FX Rates as the List Formatted line item for future references but this problem has me intrigued