find which combination equals amount

[BRRLL99]

Hi Team,

I have following Amounts, which needs to be set off based on the combination of Amounts.

Input:

Amount
76.04
42.96
-119
70
30
-100
6
88

Expected Output:

Amount	Category
76.04	M
42.96	M
-119	M
70	M
30	M
-100	M
30
88

Solved: Re: Reconciling transactions (find which combinati... - Alteryx Community

I have tried to apply this solution, 
this is applying to Many to one combination ( M:1) only.

@BenMoss @binuacs @mceleavey @PhilipMannering 

[BRRLL99]

@MattLi 

Have multiplied the data with 100 ?? 
Foe Many to Many matching to work

[MattLi]

for each row in the dataset, from top to bottom, I multiply 100, 99, 98, 99 .... etc.

so the value in top is placed with heaviest multiplication, ones in bottom with lowest.