General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Sum the column and add new row

Thiviya
8 - Asteroid

Hi,

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

 

Thanks

5 REPLIES 5
ShankerV
17 - Castor

Hi @Thiviya 

 

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

Thiviya
8 - Asteroid

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

ShankerV
17 - Castor

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
8 - Asteroid

Thanks

Thiviya
8 - Asteroid

Thanks. It worked

Labels
Top Solution Authors