topic Re: Adding a name to a row total in Alteryx Designer Desktop Discussions

Adding a name to a row total

Sophie95 — Wed, 16 Oct 2019 15:52:44 GMT

can I add a row name my grand totals at the bottom of each I would like the name under column Entity Code .example:

Region Country Entity Code TX-15 TX-200

BB Canada J150 650 750

BB Canada C57 770 951

BB US M29 800 700

BB Total entity name here 2220 2401

Re: Adding a name to a row total

BrandonB — Wed, 16 Oct 2019 15:57:22 GMT

Something like this can be achieved with a formula tool up top prior to the union

Re: Adding a name to a row total

Sophie95 — Wed, 16 Oct 2019 18:36:21 GMT

@BrandonB the way I tried adding the name in the Formula tool as you suggested but it did not work. I ended up created a new column instead. I am doing it very wrong. Can I see the updated workflow>

Re: Adding a name to a row total

BrandonB — Wed, 16 Oct 2019 18:45:00 GMT

Workflow is attached!

Re: Adding a name to a row total

Sophie95 — Wed, 16 Oct 2019 19:50:03 GMT

@BrandonB thank you, appreciate the help!