Fill pivot table Fromdate to Todate

[#1]

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

[fosuzuki · Accepted solution]

Hi Lavi,

check the attached sample...

[#3]

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

[fosuzuki]

Lavi,

try removing the following code from the ResourceLedger LOAD statement:

Date(FROMDATE) as MasterDate,

[#5]

Thanks Fernando perfectly worked.

thanks Lavi