Get Data From Combination to List item to Line item

143kishornaidu
143kishornaidu
edited July 15 in Modeling
Screenshot 2024-07-03 134321.png

Source: We have combination list and its properties with QTY value Target : I am using individual list except Application.i want application value by line items. Without using Application Dimension.

Best Answer

  • Akshara
    Akshara
    Answer ✓

    HI

    I think this helps you finding the solution.

    1. Create a staging module which holds application as dimension.
    2. Bring the aggregated value at application level using SUM function on list property "Application"
    3. In the target module you can pull this aggregated value my LOOKUP on this Application line item.
    image.png
    image.png
    image.png

Categories