Any way to do the allocation after the cross tab

[Ewbkm]

I am not sure if there is any way I can do the allocation through Alteryx or I should just export to Excel to finish the allocation. 

After I summarized the revenue and expenses and calculate the profits per each salesperson per month and I need to allocate the bonus based on the % of total profits.  The data looks like below.  The data after the cross tab is something like below: (xCol is the % of total calculated through the Alteryx)

	Dec-21	xCol_Dec-21	Jan-22	xCol_Jan-22
1	5	10	6	10
2	6	12	20	33.3333333
3	2	4	8	13.3333333
4	6	12	10	16.6666667
5	21	42	11	18.3333333
6	10	20	5	8.33333333
Total	50	100	60	100

For Dec, the total bonus to distribute is $120 and for Jan is $80.  The expected distribution result will be like below, distributed based on the xCol_Dec-21 and xCol_Jan-22 %

Hopefully, there is a simple way to enter the amount and complete the allocation.  Thanks in advance for any suggestion.  

[Luke_C · Accepted solution]

Hi @Ewbkm 

The percentages is the difficult part for this, which you already have done with the 'x' columns. How are the bonus amounts being input? In it's simplest, for december you could do a formula tool with the following:

120 * ([xCol_Dec-21]/100)

In practice, you may want to have the bonus amounts entered and appended to the data set to aide in the calculation