6 Replies Latest reply: Jan 26, 2016 4:52 AM by Fateh FATEHCH RSS

    load the max date in the pivot table

      Hi all member

      i Used a pivot Table to get a max date for any task

      i used task like demension and the max date in expression(its necessary to use it like this)

      i have two script

      this Tache is a concatination between other field, and join it with other table :

       

      for the first  script :

      load

      Distinct NameTache&'-'typeTask as Tache,

      (MakeDate(1900+left(DateTask,3))+mid(DateTask,4)-1) as DateTask ;

      SQL SELECT

      ,

      NameTache,

      typeTask,

      DateTask   // the max methode doesn't work here max(DateTask) as dateMax  an error message apear  that we cann't put the max methode

      FROM "database" ;

      -------------------------------------------------------------------

      for the second  script :

      load

      Distinct NameTacheee&'-'typeTaskeee as Tache,

      SQL SELECT

      NameTache,

      typeTask,

       

      FROM "database" ;

      please i have tired to resolve this problem but i cant get it

      - i used variable vMAxdate =max(DateTask) and i used it in expression in the my pivot table but doesn't work

      - i tried to used it in script to load the max date like:

      max(DateTask ) as DateTask_ also doesn't work


      please help me