Iterative macro

[Raj]

The attached file contains Purchase and Redemption Transactions for some Funds Units purchased and sold. Based on FIFO allocation, compute the Realised Gain on Redemption and present the output as follows: ISIN, No of Units Purchased, Purchase Amount, No of Units Redeemed, Balance Units, Balance Amount, Realised Gain/Loss

Please help , Thanks in advance

[AshRez]

You can use Summarize like below

[Raj]

Thank you for this but i was looking for something different which is not related to summarization

[apathetichell]

This is a community to provide help with Alteryx problems - perhaps you should take another tact when looking for an end to end build - like hiring a consultant or doing it yourself? When you run into problems on your build - I'm sure someone here can help you troubleshoot your build.

[Raj]

Hi, Thanks for the advice

But I was not expecting a end to end build from your end 
just looking for a iterative solution for such scenarios.