In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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