vbastarter wrote:
Have a pivot report with dates. I like to data sort by date in ascending
order. so i did sort and top 10 - asending

but i keep getting dates in this order -
11/07/2005
12/07/2005
13/06/2005
13/07/2005

These are sorted lexicographcally, which suggests that the dates
must be in text format in the source data.

but i would like to get in this order

11/07/2005
12/07/2005
13/07/2005
13/06/2005

But this isn't ascending order - 13/06/2005 should come first.
I assume there's a typo in there somewhere (e.g. should be
13/06/2006 or 13/08/2005)

How can i achieve this ???

Either fix the source data so that you have genuine dates rather
than text, or add an extra column: you can convert a "text date"
to a real one by using the VALUE() function and formatting as
dd/mm/yyyy; then pivot on this column instead of the text dates.