Total SUM on one distinct column.

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!

Developer

Reporting

Join

Expression

Accepted answers

IraWatt

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

Totals Column.yxmd

All comments

IraWatt

Hey @JPAEP,

Does something like this work?

Totals Column.yxmd

binu_acs

@JPAEP something like this?

sum_20_05.yxmd

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.

binu_acs

@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

Altyerx Test Data.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703