Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about 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.

ACE Emeritus
ACE Emeritus

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.