•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
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
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#Pivot Table
#Excel
#date column
#sorting
#MMM-YY format
#workaround
#source column
#alphabetically
#manual arrangement
#sorting issue
#issue
#reliable answers
#date value
#rows