How to allocate an amount to rows based on the row percent of the total

[JTWilliams]

Hello Community

Very new to Alteryx.  Need help creating an allocation of a dollar amount to many rows based on each row's percentage of the total amount.  Guessing this is a simple / basic calculation but not sure which tools to use to solve this problem.  See sample below.

Items 1 through 7 are filtered from a larger data set.  These are run through Summarize tool to calculate the Quantity total.  The material handling amount is added manually from Text input.  All three are brought together through the Join tool with the output below.  How can the $-95K be allocated to each Item row based on its percent of total quantity?

Also, the number of Items (rows) could change in subsequent data runs.  Is there a way to make sure the flow works if there are more or less rows?

Thank you for your input.

Sample data attached.

TYPE	Description	Quantity	Account	Dollar Amount
R1	Item 1	27113.26	211000000.114100.812
R2	Item 2	6259.49	211000000.114100.804
R3	Item 3	93.22	211000000.114100.816
R4	Item 4	2898.34	211000000.114100.806
R5	Item 5	93.22	211000000.114100.816
R6	Item 6	3478.00	211000000.114100.814
R7	Item 7	34.27	211000000.114100.814
	Total Quantity	39969.80
	Total Material Handling		211000000.114100.900	-95844.9

[binu_acs]

@JTWilliams One way of doing this

[JTWilliams]

Thank you for the solution. This is very helpful.