Sort date and get recent date in Split functionality subset

Hi All,

I'm attempting to retrieve some information about the audiances, where in we have used the split activity to split the audiances and sorted by the brand's selling date. Adobe is pulling the results for the earliest date rather than the most current date, nevertheless, after applying the split activity.

Could someone please tell me how to retrieve the most recent date and data from the activity?

Adding the screenshots for ref:

I've tried in both ascending and descending orders still its pulling down the older data not the recent one.

Appreciating the quicker response.

Thanks!