SUM on non-shared Dimensionality
I have a Target module which is Dimensionalised by Line Items and Time and a Source module which is dimensionalised by a numbered list and 3 line items (1 is direct input and 2 are List Formatted (1 being Time, 1 being Line Item Sub-set of the Target module Line Items)
In my Target module I wish to return the Direct Input line item from the source module and SUM on the Time formatted Line Item and Line Item Sub Set. The problem being is the Line Item in the Target Module and the List Formatted Line Item in the Source module have effectively no relationship
Is there a SUM/SELECT formula whereby you SUM on a Line Item but SELECT which List Item to SUM on?