3 Replies Latest reply on Sep 12, 2016 3:51 PM by Russel Quan

    Excel Date MMM-yy doesn't Pivot correctly

    Russel Quan

      I have an excel table with dates in the Mmm-yy format.

      t1.png

      When I pivot the values in Tableau and change the type from Abc to Date, it returns Nulls.

      t2.pngt3.png

      If I change the format to mm/dd/yy, then the pivot and type change from Abc to Date works fine.

      t4.png

       

      I'd like to leave the excel table in its original format.

      Any suggestions?

       

      Thanks in advance.  Russel