Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Alteryx Summarise Tool

henrygeorge
8 - Asteroid

Hi

How do I get a grand Total of all the counts. My result right now is -

 

Count
2
23
5

 

I want my output to have another row item for grand total

Count
2
23
5
30
2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

CReW macros to the rescue!

 

chaosreignswithin.com

 

We have an add totals tool.

 

cheers,

 

mark 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
fmvizcaino
17 - Castor
17 - Castor

Hi @henrygeorge ,

 

Attached is an example showing how to get that done with summarize tool.

 

Let me know if that works for you.

Best,

Fernando Vizcaino

Labels