I am trying to sort a table to show on a datastudio report, the problem I have is that I need to sort out values by Name and By the latest date, this is to keep track of a servicing regime, I want to create a report that shows only the name of the latest service done on the "bike" to ignore older services for same customers. I kinda made it work but it still shows duplicate names and I cannot work around it :(

Then after I have that how would I have another sheet that shows the upcoming services next week (we service every 8 weeks)

Hope I make sense. I am using Google Sheets and here is the Link to the sheet

Thanks in advance!

CodePudding user response：

see:

=SORTN(SORT(B2:E, 1, ), 9^9, 2, 2, 1)