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.
GELÖST

Sum the column and add new row

Thiviya
Asteroid

Hi,

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

 

Thanks

5 ANTWORTEN 5
ShankerV
Castor

Hi @Thiviya 

 

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

Thiviya
Asteroid

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

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

Thanks

Thiviya
Asteroid

Thanks. It worked

Beschriftungen