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

How to get total by column

imrahu01
8 - Asteroid

Can someone please help me to get total by each column? I attached "desired output" tab as example of what I am trying to do.

5 REPLIES 5
JosephSerpis
17 - Castor
17 - Castor

Hi @imrahu01 the crosstab has the option of a total row which can utlise. I mocked up a workflow to showcase this. Let me know what you think?

 

Total_row.JPG

messi007
15 - Aurora
15 - Aurora

@imrahu01,

 

Please see below:

messi007_0-1612543140956.png

Attached the workflow,

Hope this helps!

 

Regards

imrahu01
8 - Asteroid

Thank you. That works @JosephSerpis 

imrahu01
8 - Asteroid

@messi007 Thanks. That also worked 🙂

messi007
15 - Aurora
15 - Aurora

@imrahu01,

 

Happy to help 🙂

 

@JosephSerpis I like your provided solution I didn't know that you can have total for Cross Tab thanks for sharing 🙂

 

Best Regards,

Labels