none
Sorting datetime Column

    Question

  • Hi,

    I'm using the latest version of PowerPivot in excel 2010.

    In my PivotTable i have a column of type DateTime, i'm trying to sort but "sort A to Z" or "sort Z to A" the result is the same , all the information show random not sorted in any way.

    I have another column with the time in milliseconds (bigint) and the sort doesn't work either.

     

    Could anyone help me on this ? Maybe i'm doing something wrong...

    Thanks in advance,

    Rui Santos

    Wednesday, February 23, 2011 3:51 AM

Answers

All replies