Hi All,
I have a situation where i need to calculate MTD and YTD based on weeks. I'm using Fiscal Calendar and my weeks are also
created based on date ranges.
W1,W2,W3,W4,W5 are calculated as Sales/Qty.
Based on the week values , i have to go with creating MTD for that Month and for subsequent months too and finally YTD from Apr to till date.
Please find the screenshot for the same.
Any example code snippet or links would be a great help.
Regards,
Srinivas K