I'm trying to add a table which will show the most recent 10 orders by customer. I have a customer level filter, so if I choose a customer then the table shows only orders relating to them.
I've added in a visual filter, 'Top N', and selected to show the latest 10 by date. However if there were multiple orders on a given date (see pic) then it returns more than the 10 latest orders - it counts the 10 latest unique dates, allowing duplicates.
How do I redo this so that the total count of orders I get returned is 10, not the total count of unique dates? Also worth adding sometimes 'Order' returns a number greater than 1 for a given row, though in the example below they are all 1s.
'Orders' is a measure
Thanks for any help
