help on pivot table

[marcorizzo]

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

[er_mohit]

hiiii

see the attached file

[marcorizzo]

Sorry but it doesn't work.

I was wrong because the sql table is a bit different :

DATE	TYPE	CODE	EMPLOYEE	FATHERCODE
01/01/2010	CONTRACT	CON001
01/02/2010	CONTRACT	CON002
01/03/2010	TECHNICAL INTERVENTION	-	MARK	CON001
01/04/2010	TECHNICAL INTERVENTION	-	JOHN	CON002
01/05/2010	TECHNICAL INTERVENTION	-	PAUL	CON002
01/06/2010	TECHNICAL INTERVENTION	-	DAVID	CON001
01/07/2010	TECHNICAL INTERVENTION	-	PAUL	CON002

So I cannot use the date ad dimension.

I really don't know how to go on.