Can not get max of date at the higher level

Hi there,

I'm facing a big problem that I’m not able to get the maximum of date group by at rows, my insight will break down by that date level.

I want to get the most recent listing date of “Subdivision Name” and “Region Name”, example at Subdivision is ‘Crane Landing’ has “Most Recent Listing Date” = ‘02/21/2022’.  Any ways to do this?

Thanks for your help!