Pivot Table not sorting the date column accurately

Hello excel experts,

i have an issue where sorting my date column in pivot table is not actually sorting by the date but rather sorting alphabetically.

The weird thing is that my source column is definitely a date value in MMM-YY format.

I've asked chatgpt but the answers dont seem reliable.

Was wondering how you guys have worked around such an issue? For now i'm manually arranging the pivot table rows