Free Trial

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