Hi everyone!
I am trying to replicate a SumIF (i guess) in Alteryx.
As you can see in the picture, I have in the first column an Item Code, in the third a number representing a transaction quantity and in the fifith the total quantity after the transaction.
I want to create a new column with the sum of all the transaction quantities for any give item code. For example, for the item in the picture I want to have a new column that, for each of the 7 rows with that Item Code, shows the results of all the transactions in the third column (49 in this case)
Do you now how I can replicate this in alteryx knowing for any given item I might have from 2 to potentially infinite transactions?
Thank you for your help!
