community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Conditional Summation

Highlighted
Asteroid

I have a database of people with unique distinctions in a separate column.  I'm looking to create a new column for the sum of people by distinction (i.e. Column C would be total headcount of people with distinction x, Column D total headcount with distinction Y, etc.).

 

What formula should I be using in the formula tool (one for each new column)? The count formula counts the words, but I essentially just need to count the number of rows.


Thanks!

Alteryx Partner

If I'm understanding correctly, by unique distinctions you mean that each person only has a single distinction. In this case, you could do a GroupBy on Distinction, then count on a unique identifier or something. From there, you'll have each row being a distinction, with a column for name and a column for the count. You could convert this to the format you specified using the cross-tab tool.

 

Labels