Lookup value from the other line of the same Table

[dimk23]

Hello valuable supporters. Im looking for to bring the values of rows frome the same table to the other rows, under some conditions. For example i need the sum of product in the same table to transfer to the Main Product-Item, specifically the Item 33010022

I have two sub Item (Side1, Side2), i need the totals per department,year and when the Sides of Item= is not null, adding the value of columns Value and kilos. Imagine in the table thousands rows of that. Can i retrieve those values with a measure and not to refer to other table? The second part of image is the visual as Table and the desired outcome. thank you

[dimk23]

Thank you for your reply (Scott Chang). It is not 100% disered outcome (as measure) but is very nice approachemnt and gives prospect because the case technically is little strange. I accept it as the solution with 85% as accomplisment (without any intension to decrease your try 🙂  etc) in comparison with my personal desired outcome 🙂 . Thank you again for your time. 

[Anonymous · Accepted solution]

Hi @dimk23 ，

It seems impossible to achieve the table style you want, because in your description value and kilos are fields, so you can only create two additional measure to detect these two values, you can check the results as follows:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.