Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hiiii
see the attached file
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.