faced the issue regarding with the excel column while working on dataset , the issue was like i didn’t able to sort the dates (asc/desc) while creating pivot table for the same.
some of dates were in the text format ,I even converted those dates in date format using date() function so that i can get all the dates in same format but then too issue didn’t get resolved.
below sharing pivot table screenshot
help me in this.