3 Replies Latest reply: Mar 27, 2018 12:43 PM by Mike Boreham RSS

    CrossTable and dates

    Lukas Roček

      Hi all,

      I have a problem with crossTable Load. I have this table in Excel:


      I use this code:



      CrossTable (Months,Utilization)


          Name as WorkerName,




      FROM [path.xlsx]

      (ooxml,embedded labels,  table is Sheet1);

      I need to view dates, but when I try to convert it to date, no results (Date, Timestamp...)

      How to load this data? Especially for a heatmap?

      Thaks a much for your ideas