MTD and YTD of Hours in Table Chart or at script level

[Praneeth_Konduru]

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