I have a situation where I am to show the 'most recent ' customers in a data set. Most recent means the latest invoice date.
but the data is being processed grouped by invoice number.
if i try to sort by date descending, it doesn't let the date be more in higher position than the Invoice nbumber.
this seems simple enough but how do i make the selection display to be by most current date.