4 Replies Latest reply on Sep 8, 2016 7:01 AM by kettan

    Pivot Tables cause Date anomolies?

    Chris Fountain

      Hi everyone,

       

      I have a Pivot table with dates across the top

       

      January 2013 February 2013 March 2013

       

      (etc.) separated by excel columns

       

      I pivoted the data underneath the dates in the built in data source tab.

       

      It correctly shows:

       

      January 2013      3000

      February 2013    3300

      March 2013        2500

       

      When I convert the type to 'Date' it shows only nulls.

      When I custom the date format to mmmm yyyy it stays null.

       

      Is it an error the way Pivot tables does dates? Seems like something that should be so simply and easy, and driving me a bit batty!

       

      Thanks!