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
20 - Arcturus

@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
20 - Arcturus

@tmitchell30 attach your input excel file as well

Labels