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"