View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vbastarter
 
Posts: n/a
Default urgent pls! sort date pivot report

Also, i have count and sum formulas in the report, does this effect sorting ?

"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

but i would like to get in this order

11/07/2005
12/07/2005
13/07/2005
13/06/2005
How can i achieve this ???