10 Replies Latest reply: Dec 8, 2015 4:25 PM by Olivier Sinquin RSS

    adding columns after crosstable

       

      I need to add a few columns after I pivoted an excel spreadsheet and I can’t find indications about where I should put the instructions.

      I tried the following but the columns get added as rows (the get pivoted) J

       

      CrossTable(KPI, Data)

       

      LOAD F1 as "Date",

       

           [Number of Project] as [Number of Projects] ,

       

      "Number of Project" / 10 as "Number of projects - KPI"

       

      FROM…