Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi community i m facing the problem but can't get success.
i appreciate for any kind of help from your side m using personal edition
I have two table.
Table1:
EmpCode | Date |
278 | 5/1/2013 |
278 | 5/2/2013 |
278 | 5/3/2013 |
278 | 5/4/2013 |
278 | 5/5/2013 |
278 | 5/6/2013 |
278 | 5/7/2013 |
278 | 5/8/2013 |
278 | 5/9/2013 |
278 | 5/10/2013 |
278 | 5/11/2013 |
278 | 5/12/2013 |
278 | 5/13/2013 |
278 | 5/14/2013 |
278 | 5/15/2013 |
278 | 5/16/2013 |
278 | 5/17/2013 |
278 | 5/18/2013 |
278 | 5/19/2013 |
278 | 5/20/2013 |
278 | 5/21/2013 |
278 | 5/22/2013 |
278 | 5/23/2013 |
278 | 5/24/2013 |
278 | 5/25/2013 |
278 | 5/26/2013 |
278 | 5/27/2013 |
278 | 5/28/2013 |
278 | 5/29/2013 |
278 | 5/30/2013 |
278 | 5/31/2013 |
278 | 6/1/2013 |
278 | 6/2/2013 |
278 | 6/3/2013 |
278 | 6/4/2013 |
278 | 6/5/2013 |
278 | 6/6/2013 |
278 | 6/7/2013 |
278 | 6/8/2013 |
278 | 6/9/2013 |
278 | 6/10/2013 |
278 | 6/11/2013 |
278 | 6/12/2013 |
278 | 6/13/2013 |
278 | 6/14/2013 |
278 | 6/15/2013 |
278 | 6/16/2013 |
278 | 6/17/2013 |
278 | 6/18/2013 |
278 | 6/19/2013 |
278 | 6/20/2013 |
278 | 6/21/2013 |
278 | 6/22/2013 |
278 | 6/23/2013 |
278 | 6/24/2013 |
278 | 6/25/2013 |
278 | 6/26/2013 |
278 | 6/27/2013 |
278 | 6/28/2013 |
278 | 6/29/2013 |
278 | 6/30/2013 |
278 | 7/1/2013 |
278 | 7/2/2013 |
278 | 7/3/2013 |
278 | 7/4/2013 |
278 | 7/5/2013 |
278 | 7/6/2013 |
278 | 7/7/2013 |
278 | 7/8/2013 |
278 | 7/9/2013 |
278 | 7/10/2013 |
278 | 7/11/2013 |
278 | 7/12/2013 |
278 | 7/13/2013 |
278 | 7/14/2013 |
278 | 7/15/2013 |
278 | 7/16/2013 |
278 | 7/17/2013 |
278 | 7/18/2013 |
278 | 7/19/2013 |
278 | 7/20/2013 |
278 | 7/21/2013 |
278 | 7/22/2013 |
278 | 7/23/2013 |
278 | 7/24/2013 |
278 | 7/25/2013 |
278 | 7/26/2013 |
278 | 7/27/2013 |
278 | 7/28/2013 |
278 | 7/29/2013 |
278 | 7/30/2013 |
278 | 7/31/2013 |
Table2:
EmpCode | StartDate | EndDate | No. Of Absent |
278 | 5/30/2013 | 5/30/2013 | 1 |
278 | 6/20/2013 | 6/20/2013 | 1 |
278 | 6/29/2013 | 7/2/2013 | 4 |
Now i want output like below when i select the particular month in calender.
Output | ||
EmpCode | No . Of Absent | |
278 | 1 | when user select May In Calendar |
278 | 3 | when user select june In Calendar |
278 | 2 | when user select july In Calendar |
my calender like this
year | 2013 |
Month | May | June | July |
Thanks & Regards
You can transform your Table2 to a table that contains a record per absent date, like discribed in this blog post.
Then just link this table to a calendar, use Month as dimension and count(AbsentDate) as expression.
Hope this helps,
Stefan
You can transform your Table2 to a table that contains a record per absent date, like discribed in this blog post.
Then just link this table to a calendar, use Month as dimension and count(AbsentDate) as expression.
Hope this helps,
Stefan
sir
when i select month june then i want output in pivot like-
EmpCode No. Of Absent
278 3
similarly
when i select month july then i want output in pivot like
EmpCode No. Of Absent
278 2
Thanks & Regards
please help me urgently to solve this problem.
This is basically using the same logic to the blog and idea suggested by swuehl.