locked
Strange behavior of pivot RRS feed

  • Question

  • I just ran into a strange behavior of the pivot mechanism. First, some details: I am using office2010, english installation, with regional settings of Italy (so date is dd/mm/yy, currency is euro), but I keep the dot as decimal separator.

    I have a table with n records, each for a different member of a local club. One column, naturally enough, has the heading "last name". I try to insert a pivot table, and use the last name field as row heading. I would expect that the rows get populated with all last names in alphabetical order. This is not so, because before the first last name with "A" there are two names: Marzo and Maggio. These happen to be last names equal to the names of two months in Italian: March and May. After some thinking, I added a fake last name to the data base, with last name  = Dicembre (December), and in fact also this one gets listed at the beginning, before the "A". In other words, the pivot table puts at the top the names of the months (in their proper order) before starting the regular alphabetical list. This does not seem to happen if I insert fake names using the month names in English. Is there an explanation for this, or is it just a plain bug?

    Thank you

    Robert, Italy

    Saturday, March 30, 2013 1:24 PM

All replies

  • Robert,

    That's weird.  I ran a test to see if I'd get the same error, and no moatter the sort criteria, it reverts back to the same .... exactly as you described.  I've seen unchecking the 'use custom lists' box work before, but not in this case.

    I'd test editing the text - Putting a period after the "month name" seems to do the trick and is not much of an eyesore in the presentation.

    Monday, April 1, 2013 7:09 AM
  • Tnanks for your answer.I'll tell you something more, if you are interested.

    The same behavior is found in excel 2003, so it is not a recent issue. Then, then same thing happens for every predefined list, e.g weekdays, and also for user defined lists. Oddly enough, it does NOT happen for the abbreviation list: that is, it happens for Gennaio, Febbraio, Marzo.... (January, February, March...) but not for  GEN, FEB, MAR... (Jan, Feb, Mar,...). As a friend said, more than a bug, it looks like a (undocumented) feature.

    The solution you propose works, but is not very elegant. Would it be possible to have somebody from Microsoft tell us their view on the topic? 

    By the way, this only happens in the pivot tables: if you sort the source database table with the standard procedure, the data are sorted correctly. 

    Monday, April 1, 2013 9:19 AM