Hello all,
I have timesheet data with start date, end date, month, hours data as below from Jan 2021 to Jun 2021. I need to set up a filter as Time_Period (Month Year such as May-2021) and display a table with start date, end date, month, MTD of Hours and YTD of Hours. I tried several expressions by following several posts but unable to achieve the right values for YTD. MTD simply works perfectly by using sum(hours) but as soon as i input YTD expression for the table it does not work.
Please help, I am unable to figure out YTD specially since the data is at different levels, since same employee could work in different projects with different with different cost center # etc. So when i select a monthyear from filter (eg: May-2021), I should display all the below columns with MTD hours and YTD hours for each month for each employee in whichever projects they worked in. Sample data pasted.
| Task or WBS element |
Project |
Employee ID |
Company |
Cost Center # |
Cost center name |
Month |
Start date |
End date |
Hours |
| 1 |
1 |
84737 |
0120 |
38 |
A |
January |
04-Jan-2021 |
10-Jan-2021 |
24 |
| 2 |
2 |
84656 |
0120 |
267 |
B |
April |
05-Apr-2021 |
11-Apr-2021 |
4 |
| 2 |
2 |
107158 |
0120 |
512 |
C |
March |
29-Mar-2021 |
31-Mar-2021 |
20 |
| 2 |
2 |
136135 |
0120 |
19 |
D |
April |
26-Apr-2021 |
30-Apr-2021 |
18 |
| 2 |
2 |
76636 |
0120 |
267 |
B |
February |
22-Feb-2021 |
28-Feb-2021 |
8 |
| 2 |
2 |
84656 |
0120 |
267 |
B |
March |
01-Mar-2021 |
07-Mar-2021 |
30 |
| 2 |
2 |
78890 |
0120 |
19 |
D |
June |
14-Jun-2021 |
20-Jun-2021 |
20 |
| 2 |
2 |
80778 |
0120 |
19 |
D |
February |
22-Feb-2021 |
28-Feb-2021 |
6 |
| 2 |
2 |
83713 |
0120 |
19 |
D |
June |
01-Jun-2021 |
06-Jun-2021 |
188 |
| 2 |
2 |
136135 |
0120 |
19 |
D |
January |
04-Jan-2021 |
10-Jan-2021 |
16 |
| 2 |
2 |
136135 |
0120 |
19 |
D |
March |
01-Mar-2021 |
07-Mar-2021 |
14 |
| 2 |
2 |
78890 |
0120 |
19 |
D |
May |
03-May-2021 |
09-May-2021 |
76 |
