I have a report that shows the very last delivery time for each truck in a fleet.  When the report is grouped by state, the truck shows up in multiple states with the last delivery time it had in that state .

 

Is it possible to have it group by state and only have it show up in the correct state and not multiple states? 

 

Not sure if I made sense.

 

THANKS