Parent to Child Lookup/Selection - Part II
Does anyone know if there a best practice around sourcing data where the target module is dimensioned by a parent list and the source is a child list?
Target Module: Roles
Dimensions: Team Roles, Staging Opportunity
Target Line Item: SF User ID
Formula: Teams.'Item: SFDC User'
Source Module: Teams
Dimensions: Staging Teams
Source Line Item: Item: SFDC User
My initial instinct was to use SUM however that would not work on a list formatted line item. Also, in this case, creating a mapping table isn't practical as there are hundreds of data rows.