Pivot Table - Date Report Filter

Hi all,

I have been trying to create a Pivot table that shows all the clock ins/outs made on a date that you select via the report filter drop down and display it on a line graph to see the peaks and lows. To this extent, it works perfectly.

One thing I have noticed though, is how on pivot table refresh, the order in which it is displayed isn't in the correct order (1 Jan, 2 Jan etc) but is displaying starting at the 10th Jan. All the dates are still there, but some days of the month display at the bottom rather than the top. Any ideas why?

Thanks