Hi all,
I need to create a new column in a table that shows the incremental payments amount for each transaction. I have attached sample dataset to this post and pictures of what I would like to have.
Before:
After:
Any help would be appreciated, thanks!
Hey @peterg97,
You just need a multi row like this:
The multi row formula groups my transaction and minus the previous transaction from the current. Please ask if any questions :)
HTH,
Ira