I can help you with hiding the last value, if you double click on the rows, you can create an adhoc calculation by typing in last()
Now drag this field into the filters shelf, right click and convert it to discrete and edit the filter so that 0 is excluded:
This will remove the maximum date value from the view.
Hi Mavis and Neil,
Thank you very much for your help.
Neil's answer is what I am looking for more specifically, so I'll mark that one as correct.
Very helpful both of the answers though, thanks!