Data Messaging: GroupBy

Great,
Check this reply: Group By: Maximum - #6 by hemanshu.rukadikar

This should help your case too. Give it a try and let me know if this works