Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Adding a name to a row total

Sophie95
8 - Asteroid

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

4 REPLIES 4
BrandonB
Alteryx
Alteryx

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

 

Totals.png

Sophie95
8 - Asteroid

@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> 

BrandonB
Alteryx
Alteryx

Workflow is attached!

 

config.png

Sophie95
8 - Asteroid

@BrandonB  thank you, appreciate the help!

Labels