In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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