Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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