Dataset returning multiple records - need to filter down to the newest

HI all
I’m trying to work out how to filter down to the newest record - in the screen shot this would be datecomp = -1. all the duplicates are older records and i need to filter them out.


Hello @evansstu,

Welcome to QuickSight Community, it is great to have you here!

Have you looked at Top and Bottom filters, I think they should work well for your use case.

Hope this helps!

Kind regards,


Thank you so much… works a treat !!

1 Like