Tags: based, date, excel, grouped, microsoft, msdn, numerically, pivot, software, sort, sorted, sorting, table

Pivot Table, Date Sorting?

On Microsoft » Microsoft Excel

1,519 words with 1 Comments; publish: Thu, 22 May 2008 23:42:00 GMT; (30693.75, « »)

I have a pivot table with the data grouped by year,month, date. Year and Month sort ok, but date seems to be sorted numerically based on the day. I get the following: 10 - 30 followed by the dates 1 - 9. I've changed the date format to several different formats with no luck. I've double-checked to sort order and everything looks ok. Any Ideas?

All Comments

Leave a comment...

  • 1 Comments
    • Sounds like they are not real dates, but are in fact either a numerical representation of

      a date or text. They need to be real dates in a format that Excxel recognises to sort

      properly, otherwise you will get exactly the problem you have got.

      --

      Regards

      Ken.................. Microsoft MVP - Excel

      Sys Spec - Win XP Pro / XL2K & XLXP

      ----

      Attitude - A little thing that makes a BIG difference

      ----

      "Steve" <anonymous.excel.questionfor.info.discussions.microsoft.com> wrote in message

      news:A263602F-8DFB-438B-8BD3-F55EA03772BF.excel.questionfor.info.microsoft.com...

      > I have a pivot table with the data grouped by year,month, date. Year and Month sort ok,

      but date seems to be sorted numerically based on the day. I get the following: 10 - 30

      followed by the dates 1 - 9. I've changed the date format to several different formats

      with no luck. I've double-checked to sort order and everything looks ok. Any Ideas?

      Outgoing mail is certified Virus Free.

      Checked by AVG anti-virus system (http://www.grisoft.com).

      Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003

      #1; Thu, 22 May 2008 23:44:00 GMT