Total SUM on one distinct column.

[JPAEP]

I've looked on how to solve this with the summarize tool, but I cannot get the desired response. I need to have the sum of the total cost column below in a new column in one instance of the v_Root_WO. Then I will roll that back into a Find and Replace using the v_Root_WO to show up with one instance of the sum of Total Cost

Any help is appreciated!

[IraWatt]

Hey @JPAEP,

Does something like this work?

[binuacs]

@JPAEP something like this?

[JPAEP]

I've tried the union, I cannot get that work either. It keeps showing up Null in each case when I need the v_Root_WO to have the sum of the Total Cost in one Column. I know a Pivot in Excel can do what I need but was trying to bypass that step.

[binuacs]

@JPAEP Can you provide some sample data and expected output

[JPAEP]

Here is the data set in Excel. In a perfect world I would want the Sum of Total Cost in a new Column like this based on one instance of the v_root_WO

[IraWatt]

This works @JPAEP 

[IraWatt · Accepted solution]

@JPAEP This solution will work if you have multiple instances of v_root_WO:

[JPAEP]

Thank you so much! Now I just need to bring it back it to merge with another set.

[IraWatt]

Great to hear @JPAEP ! if any issues make sure to ask :)