Forum Discussion
Rankx: Finding the Last Transaction per Contract within a Date Period
Good day all, I have a table with multiple banking transactions in per contract. A batch of transactions is run on a pecific date for multiple contracts. The client wants to see what all the last...
Anonymous solution is attached, tweak it as you see fit.
parry2k
Super User
Super UserAnonymous solution is attached, tweak it as you see fit.
parry2k thank you for your response and proposed solution.
The [Last Transaction Date] measure works well and after I applied it to a batch with relevant filters, it produced the correct detail as expected.
However, after applying the [Count by Status] measure, it only counts 1 instance it seems of each status, the result being:
When it should be as follows based on the detail: