I have a requirement where :
Open date Open Amount Close date Close Amoumt
202112 56456 l 202201 76589
must come as:
202201 76589 l 202202 98767
But I am not able to get the previous month closing amount as opening amount in current month.
the amount is coming from same field.
Suggestions will be helpful.