Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have a data like this with master calender.
Resource No | Date | FromDate | ToDate | REASONID |
0498 | 1/9/2012 | 1/9/2012 | 11/22/2012 | REPAIR |
2593 | 1/1/2012 | 1/1/2012 | 11/22/2012 | REPAIR |
3816 | 1/15/2012 | 1/15/2012 | 11/22/2012 | REPAIR |
8369 | 1/31/2012 | 1/31/2012 | 11/22/2012 | REPAIR |
0629 | 1/12/2012 | 1/12/2012 | 9/16/2012 | REPAIR |
2082 | 1/1/2012 | 1/1/2012 | 2/28/2013 | QUARANTAINE |
2078 | 1/1/2012 | 1/1/2012 | 11/22/2012 | QUARANTAINE |
2079 | 1/1/2012 | 1/1/2012 | 11/22/2012 | QUARANTAINE |
In pivot table i want to show
Resoure No. Mon Tue Wed...................... Sunday
Date 1/9/2012 2/9/2012 3/9/2012 ............. till 11/22/2012
0498 Repair Repair Repair.................... Repair
same for all Resource Nos
Anybody thinks this is possible?
Thanks
Lavi
Hi Lavi,
check the attached sample...
Thanks Fernando for your great example.
It really works for you but i don't know why it is not working in my file. Is it some strange that i don't know?
I m using the same code as you.
attached is the file.
thanks
Lavi
Lavi,
try removing the following code from the ResourceLedger LOAD statement:
Date(FROMDATE) as MasterDate,
Thanks Fernando perfectly worked.
thanks Lavi