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

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
binu_acs
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.

binu_acs
21 - Polaris

@tmitchell30 attach your input excel file as well

Labels
Top Solution Authors