i have a pivot table with a large array of dates, when i sort it by dd it sorts like this: 1-10-11-12-13-14-15-16-17-18-19-2-20-21 -22. I want the normal sorting 1-2-3-4-5-6-7-8-9-10-11-12. My data source is dates I don't want to make any changes to my data source (by this I mean I don't want to add any columns or formulas, the data source currently consists of 12,000 rows, so this is not an option).
It seem that your "dates" are being read as TEXT and hence that is how text is sorted. You could highlight that column and go to DATA -> Text to Columns and see if it can re-format that column to be a number. If that doesn't work I would suggest you add a column with a formula (both of which I know you don't want, BUT then copy the results of that formula as values only back onto the original data and delete the helper column so in the end the data set won't have any extra column or formula.