Forum Discussion
Show only latest version
Hi, I came across an issue i cant solve myself, and hope maybe someone ot there could help me. My data looks like the below, i want to somehow only show the latest version for a document and ...
Use a 'Group By' on Document No.
2 Aggregations : Max of Version No, and all rows
Expand the new column, then using Table.SelectRows filter only the rows where MaxVersionNo = the version no from original data.
Use a 'Group By' on Document No.
2 Aggregations : Max of Version No, and all rows
Expand the new column, then using Table.SelectRows filter only the rows where MaxVersionNo = the version no from original data.
Thank you - so simple but i simply couldnt come up with that soloution myself