Alteryx Designer Desktop Discussions

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

How to Add Total row and Total Column

cowannbell
9 - Comet

I have the below table and the numbers in the table are string because of the formatting.  How do I get a total row and total column as shown highlighted.

 

 

Alteryx.PNG

9 REPLIES 9
binuacs
21 - Polaris

@cowannbell one way of doing this

image.png

cowannbell
9 - Comet

This has worked great thank you.  I am having one issue.  I can't get the name total in the last row.  It just comes up as null.  I see that yours is working, I'm not sure what I could be doing wrong, I looked at every step you took and mine seems to be the same.

 

 

binuacs
21 - Polaris

@cowannbell you need to select the Total Column and Total row from the cross tab table, if  you scroll down you will see the options

image.png

cowannbell
9 - Comet

I have both of those checked.  The total row is there, it just doesn't say total.

 

 

binuacs
21 - Polaris

What version of designer do you have?

binuacs
21 - Polaris

just add the below formula in the name field

image.png

flying008
15 - Aurora

Hi, @cowannbell 

 

FYI.

 

录制_2025_03_20_10_00_51_143.gif

cowannbell
9 - Comet

My designer is 2022.3.1.532 Patch: 5

 

Thanks so much.  This worked great.

cowannbell
9 - Comet

How would I sort these but leave the total row at the bottom.  I have tried several ways but can't seem to get it correct.
@binuacs wrote:

just add the below formula in the name field

image.png


 

Labels
Top Solution Authors