Multi Field Binning with Equal Sum?

[DHodges]

I am trying to group my data into 4 groups with the optimal equal sums by the number of records divided by the 4 groups. In the example data below I have 11 records, so I would want three groups of 3 and one group of 2 binned by the closest equal sum among them. The "Group" column in the table was my quick guess on the desired output, however most likely there will be a more optimal solution! The number of records may change, so this would need to be dynamic. I played around with the Tile tool which gives the closest result, however I could not limit to the desired 3 3 2 groupings. 

Any help would be much appreciated!

Data Field	Value	Percent Total	# Per Group (Count Data Field/4 Groups)	Group
Data Point 1	25	24%	2.75	A
Data Point 2	22	21%	2.75	B
Data Point 3	13.00	12%	2.75	C
Data Point 4	12	11%	2.75	D
Data Point 5	11	10%	2.75	D
Data Point 6	6.00	6%	2.75	C
Data Point 7	4.00	4%	2.75	C
Data Point 8	4.00	4%	2.75	B
Data Point 9	4.00	4%	2.75	B
Data Point 10	2	2%	2.75	D
Data Point 11	2	2%	2.75	A

Thank you!

[Shifty]

Hey @DHodges - you might have already solved this but I hate seeing a question go unanswered so here's my shot:

Would the Tile tool do a job for you?

[Shifty]

Please find a workflow attached that bins your sample data into equal groups based on the Value column using the Tile tool:

It doesn't group the columns the same way as you but the groups are equal by value.  Let me know if that works as expected.

[grazitti_sapna]

@DHodges , this is as close as I could get to your solution. Please have a look.

I am not sure if this is what you are looking for. But if yes I hope it helps!

Thanks!

[Qiu]

@DHodges 
Please look at this thread.
I think this is a Bin Packing issue.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/HELP-How-to-use-ITERATIVE-MACRO/m-p/92...