Mapping between dimensions at minimal cost
I want to pull data from line item, M1.LI1, into another M2.LI2. The 1st line item is dimensioned by standard list SL1 and numbered list NL1, the 2nd is dimensioned by SL2 and SL3. NL1 has a property formatted by SL2 whilst numbered list NL2 maps SL1 to SL3 (SL1 are financial weeks and SL3 are calendar months – some financial weeks map to two calendar months so NL2 has 3 properties: SL1, SL3 and Split).
One method would be to transfer via a third line item, LI3, dimensioned by SL2 and NL2 as follows
LI3=LI2[SUM: M1.SL2, LOOKUP: SL1] where M1.SL2 = NL1.SL2
but this intermediate step costs cells. Is there an alternate method which takes up fewer cells?