Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Sum of all numbers in a column

BillyL14
8 - Asteroid

Hi there,

Please see my sample sheet where I show what I want to do. I have tried several things with the summarize tool but haven't been able to get there. Any advice?  Thanks

 

 

5 REPLIES 5
echuong1
Alteryx Alumni (Retired)

You can add a total row using the Add Totals crew macro.

 

echuong1_0-1600974689304.png

 

vizAlter
12 - Quasar

Hi @BillyL14 — Try this solution:

 

vizAlter_0-1600977115933.png

 

 

BillyL14
8 - Asteroid

@echuong1 @vizAlter  thanks!

BillyL14
8 - Asteroid

Hi @echuong1 

thanks. Where is the tool you used located? I can't seem to find it under any headings?

 

echuong1
Alteryx Alumni (Retired)

The tool I used is part of the Crew Macro pack. You can download them here:

http://www.chaosreignswithin.com/p/macros.html

Labels