Alteryx Designer

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

Adding a Percent of Total Column

5 - Atom

I am creating my first workflow to solve a process and I am stuck. For the next part of our process I need to create a percent of total column that would take, in this example, West Virginia's amount divided by the total amount. I do not have another spreadsheet that has this total in every row. Can this be done? 


My next step would be taking a single integer, input from a file, and then multiplying that by the percentage calculated above. I would then get that total by state, and add it to the existing data. 


Any help would be great as this is a core function of what we do and are trying to solve for with Alteryx.



Alteryx Certified Partner
Alteryx Certified Partner



If your total row is always "Total" you can use a FILTER tool and append that value to all other rows.  Then use a formula tool to calculate the percentage.  If the total wasn't present, you could use a SUMMARIZE tool to calculate it.







Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
5 - Atom

This is exactly what I needed! Thank you!

6 - Meteoroid

Brilliant! Such a clever use of the filter tool. Thanks!