Create a Master Calendar using Month and Year field in Data set and Show Sales for a Year
Hi Guys,
I need to create a master calendar using the month and year field provided in data source I don't have a date field what is the best possible way to create the master calendar in this situation ?
Secondly I need to show Sales for a year using this and in front end we just have month and year filter and not date filter so selecting a month and then year should give me the sales from that monthyear till last one.
Eg: if I select Mar 2018 I should see sales from Apr 2017 till Mar 2018.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful