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?

Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.

Sorting Data Based on States with Prin Bal >5%


I am looking to create a geographic distribution like the example I have included. I need to display states with principal balances over 5% of the total. How do I do this with Alteryx and display it like in the attachment. In the end, I will have more than just these two columns grouped by the state, but for now I will simplify.

Alteryx Certified Partner



Attached workflow demonstrates how this can be achieved. That first Summarize tool is the key to making this work. once you have that value, append it back to your data so it's a value available for all your records. from there, is just applying your formula.