Column Total

[MistyClark05]

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?

[kelsey_kincaid · Accepted solution]

Hi @MistyClark05 ,

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

[amazz24]

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]

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