I would like aggregar the Value from Part A to Part B, show like this:
Part
Original_Value
Shifted_Value
Total_Shift
A
15
0
15
B
23
15
38
My idea for the solve (Total_Shift) was:
if(Part = B,
sum({<Part={'A'}>}Original_Value) + sum(Orginal_Value),
sum(Orginal_Value)
)
And for the Shifted_Value I tried:
if(Part = B,
sum({<Part={'A'}>}Original_Value),
0
)
But I get only for the Part A the Values, not the other One.
