Alteryx designer Discussions

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

Column Total

Highlighted
6 - Meteoroid

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

Highlighted
11 - Bolide

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

Highlighted
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

 

 

Labels