How to Add Total row and Total Column

[cowannbell]

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.

[binuacs · Accepted solution]

@cowannbell one way of doing this

[cowannbell]

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]

@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

[cowannbell]

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

[binuacs]

What version of designer do you have?

[binuacs · Accepted solution]

just add the below formula in the name field

[flying008]

Hi, @cowannbell 

FYI.

[cowannbell]

My designer is 2022.3.1.532 Patch: 5

Thanks so much.  This worked great.

[cowannbell]

---

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

---