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?
Solved! Go to 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.
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
Following your logic - I keep getting Null values -- the actual total get created under another column.... not sure what I'm doing wrong...