2 Replies Latest reply: Feb 16, 2013 1:50 PM by Marco Rizzo RSS

    help on pivot table

    Marco Rizzo

      I have a sql table ‘TAB1’ that is more or less like this :

       

      DATE

      TYPE

      CODE

      EMPLOYEE

      FATHERCODE

      01/01/2010

      CONTRACT

      CON001

       

       

      01/02/2010

      TECHNICAL INTERVENTION

      -

      MARK

      CON001

      01/03/2010

      TECHNICAL INTERVENTION

      -

      MARK

      CON001

      01/04/2010

      TECHNICAL INTERVENTION

      -

      JOHN

      CON001

      01/05/2010

      CONTRACT

      CON002

       

       

      01/06/2010

      TECHNICAL INTERVENTION

      -

      DAVID

      CON002

      01/07/2010

      TECHNICAL INTERVENTION

      -

      PAUL

      CON002

       

      I’m trying to obtain this pivot table :

       

      DATE

      TYPE

      CODE

      DATE INTERVENTIONS

      EMPLOYEE

      01/01/2010

      CONTRACT

      CON001

      -

      -

      -

      -

      -

      01/02/2010

      MARK

      -

      -

      -

      01/03/2010

      MARK

      -

      -

      -

      01/04/2010

      JOHN

      01/05/2010

      CONTRACT

      CON001

      -

      -

      -

      -

      -

      01/06/2010

      DAVID

      -

      -

      -

      01/07/2010

      PAUL

                                           DIMENSIONS                                                                         EXPRESSIONS

       

      What do you suggest ?

       

      Please help !!!

       

      Marco