Free Trial

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
Top Solution Authors