Alteryx Designer

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

Adding a Percent of Total Column

Highlighted
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.

 

Capture.JPG

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@kmooretgt,

 

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.

 

capture.jpg

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

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

This is exactly what I needed! Thank you!

Highlighted
6 - Meteoroid

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

Labels