2 Replies Latest reply: Mar 8, 2017 6:12 PM by Mary Chen RSS

    Dates Sort differences in pivot tables

    Dafnis X



      Added a new thread here:





      This is really an annoying issue and I can't figure the reason for the inconsistent behavior of dates sort in Excel reports

      which are created in NP.


      In the following example, I exported data directly from the source model (the connection) to Excel, and the the dates are sorted as expected:


      In the pivot  created the with NP, sometimes the dates are not sorted correctly:

      You can see that the source table below is sorted , but the pivot is not.


      If I do "Text to column" on both source table, only the marked dates are formatted as dates:


      Anyone has an idea how should I resolve this?




      Message was edited by: Dafnis X added a new thread