Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Subtotal Columns

tmitchell30
7 - Meteor

How do I get totals on the columns with numbers? This is in a Basic Table. Do I need to do a formula?

Screenshot 2024-01-25 154228.png

7 REPLIES 7
binuacs
21 - Polaris

@tmitchell30 use the summarise tool to get the sum of each field then union it back with your original data

Qiu
21 - Polaris
21 - Polaris

@tmitchell30 
Do you want the Row Total or Column Totol?

We can give a try if you share the input file and desired output.

kamal03
9 - Comet

@tmitchell30 

 

You can try this workflow to get subtotal in columns, please make the adjustments in the workflow as per your needs.

 

 

tmitchell30
7 - Meteor

By Column 

tmitchell30
7 - Meteor

I need it to have all of the accounts listed and a subtotal at the bottom of the highlighted ones.

Screenshot 2024-01-25 154228.png

tmitchell30
7 - Meteor

It is the workflow on the bottom.

binuacs
21 - Polaris

@tmitchell30 attach your input excel file as well

Labels