I am using a numbered list as the dimension for a transaction log which stores changes to a people count line item applying to 7 dimensions (list items). The numbered list has each of the 7 list items as a property (format type list attached to the appropriate list item). I want to populate a line item that has been created with just 2 of the dimensions where the remaining 5 dimensions are each fixed to the value of dimensionless line items in another module. So if my dimensions are D1 to D7, the line item I want to populate, P1, applies to only D1 and D2 and the item selections for D3 to D7 are fixed. Is there a formula I can write for P1 that will LOOKUP the transaction log on the properties for D3 to D7 matching the selections for D3 to D7 and then return the SUM of the people count line item? Note that the whole point here is to keep the size of my line items as low as possible. I do not want P1 to apply to D3 to D7 so please avoid suggesting a fix that requires doing so.
