Hi , Recently I come across the similar scenario where I having a source table containing fields Cust_id, Amount , Date. At a single point of time Source table will contain the record for same month. Now I need a output with the fields Cust_id, date, MTD, YTD. .!!
I am beginner but have to complete this in given deadline. Please help me providing a way to solve this.
You can find YTD and MTD caiolculation examples here:
Please let me know if you need further help.