Add values from rows

[NRD]

Hi All,

I am in need of help in how to design the below excel file in Alteryx.

If the line item #'s are the same then I want to add the 'Base Amount' from the first record  C3 to the item amount in the cell B4. I need this new value to be in the new column 'D3'

Can someone help me with this?

[Emil_Kos]

Hi @NRD,

The summarize tool should do the trick:

Input/Output:

[NRD]

@Emil_Kos Thank you for the reply. I do not think this works for my solution. I have been leaning toward the multi - row formula tool to calculate the value in a row below the active row but I do not know how to configure it.

[Emil_Kos]

Hi @NRD,

Can you share the expected output?

[echuong1]

Are you looking to have the "new column" value applied to the first row of the line item #? 

If so, you should be able to add a record ID prior to the summarization/calculation, and then join on record ID.