Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?


Conditional sum of columns

Alteryx Certified Partner
Alteryx Certified Partner

You need a combination of Summary and the Transpose / Crosstab tools


Check out the help sections on Transpose and Crosstab and also take a look at my example.


The previous examples didn't work because the name was already set to 7 characters and when appending the additional column it was truncating it and not creating the header as they were designing.  Good job making the "header" label.  Previous examples would have worked if they changed the size of the "name" with a select tool.