Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Column Total

MistyClark05
7 - Meteor

I need to create a column total for the Diesel_ASBILLED, B99.9_ASBILLED and Total Billed Units columns on the row directly beneath the data set. Is there a fairly simple way to do this?

 

MistyClark05_0-1580421313988.png

3 REPLIES 3
kelsey_kincaid
12 - Quasar

Hi @MistyClark05 ,

You can use a summarize tool to total the columns, then union it back to the bottom of your original data set.

 

kayers_0-1580421802651.png

amazz24
7 - Meteor

Hi @MistyClark05 

 

The Crew Macro pack also has a tool that easily adds totals to both columns and rows.  Check out this article:

 

https://community.alteryx.com/t5/Engine-Works-Blog/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482

 

 

ll98
9 - Comet

Following your logic - I keep getting Null values -- the actual total get created under another column.... not sure what I'm doing wrong...

Labels