Sum the column and add new row

Thiviya

Hi,

How do I add new row to add the column from " diffference"

Thanks

Sum the differences in the column.PNG

Community

Accepted answers

ShankerV

Hi @Thiviya

Step 1: Summarize tool

Field - Differences

Action - Sum

Output Field Name - Differences

Step 2: Formula tool

Outout Column - Acct Descr

"Total"

Step 3: Union tool

Auto Config by Name

This will help you to get the expected result.

Many thanks

Shanker V

All comments

ShankerV

Hi @Thiviya

Please share the expected output, will be easy to help on the expected result.

Thiviya

Attached the output results. The highlighted is what i would like to see

Expected Output.xlsx

ShankerV

Hi @Thiviya

Step 1: Summarize tool

Field - Differences

Action - Sum

Output Field Name - Differences

Step 2: Formula tool

Outout Column - Acct Descr

"Total"

Step 3: Union tool

Auto Config by Name

This will help you to get the expected result.

Many thanks

Shanker V

Thiviya

Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703