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.
