Forum Discussion
Lastdate
Hello Team, I need help creating a table to show the last balance for my products. My table looks like the below: Date Description Balance 11/11/2022 A 30 11/11/2022 B 25 10...
Anonymous Here is the solution, hope it helps.
You can refer to the below also.
Anonymous Here is the solution, hope it helps.
You can refer to the below also.
Hi AbbasG,
I appreciate your help.
It works fine. However, if you have two transactions on the same date the table shows both transactions.
Example:
Date Description Balance 17/11/2022 A 25 17/11/2022 A 30 I need to show the latest. Is there a way?
Many thanks for your help.
Kind Regards,
Hasvine
Anonymous per my experience, there should be some data point basis on which we can identify the latest transaction. for example time stamp or a combination of date and time instead of just date.
Does your data have something like that??