Distribute values in multiple rows

[PriyamChatterjee9]

Hi all, I want to distribute a value in multiple rows using Alteryx. Let's say, the value is as below,

name	amount
abc	100

Now I want the max value in the "amount" column will be 30. That means there will be three rows having the "amount" as 30 and one extra row with the rest of the amount (here in this case it will be 10).

name	amount
abc	30
abc	30
abc	30
abc	10

Any idea on how to achieve this one. All kind of suggestions are much appreciated. Thanks!

[PhilipMannering · Accepted solution]

What about this...

[Christina_H · Accepted solution]

Try this

[PriyamChatterjee9 · Accepted solution]

Let me check with this one.  Thank you so much!

[PriyamChatterjee9]

This one also works for me. Thank you!