Forum Discussion
Sort dates in in pivot table
Hi. I have a column in pivot table for date. Why cant I sort it by date throughout the year?
The values look like dates, but they are actually text values, so they are sorted alphanumerically.
You'll have to correct this in the data source of the pivot table.