Pivot Table > Sorting Date in Ascending Order Not Working

Summary:

Pivot Table > Sorting Date in Ascending Order Not Working

Content (please ensure you mask any confidential information):

Hello,

We want to display the time card status and time card comment by weekly period (as displayed below). However, when we do so, the Date is not sorted in ascending order (even though a sort is applied in the analysis on the field). It seems a sorting is first applied automatically on the time card comment. Do you have any idea how to display the date in ascending order?

Sorting is applied on the field Calendar Date

Configuration of the pivot table layout