Sorting Dates in a Pivot Table

[johncassell]

Hi, I have a list of dates that I am creating a pivot from and it covers two years of sales.

I would like the pivot to sort it so that 01-Jan-2010 is right above 01-Jan-2011.

At the moment, the pivot will put all 2010 dates at the top and then 01-Jan-2011 will appear at the top of the 2011 dates.

Can anyone advise how to get the same dates (ignoring year) next to each other please?

Thanks
John

[johncassell]

I've sorted it now. What I did was have an extra column with just the year in. I then did a replace so that all 2011 dates became 2010. This way all the dates were treat the same but because I added the year column to the pivot, it seperated them out as I needed.

Thanks anyway
John