Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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