https://community.oracle.com/products/oracleanalytics/discussion/comment/76099#Comment_76099 Oh, I didn't even think of this approach! Thank you! I will give it a go and see how it works out for us. Thank you so much for responding so quickly!

Hiya, we use rank as the only way we could see to return the most up to date information is to rank the last update date, to then filter on the rank for 1, to allow us to see what the latest row data is. Is there another way to do it? We've been able to get the reports working correctly now as it looked to be a permissions…