Dear All,
I want to showcase 2020 Apr YTD Sales, 2019 Apr YTD Sales, 2020 May YTD Sales , 2019 May YTD Sales, 2020 Jun YTD Sales, 2019 Jun YTD Sales And so on. The all data should be in YTD and Year start is from Apr. I want to show this info using Autocalendar of QlikSense, but I got confused in getting the expected result. The year start is considered from Apr till March.
So basically I want to display YTD Sales for each month from Apr 2020 till march 2021 and 2nd column will be from 2019 Apr - 2020 March. I am getting stucked in using "inytd" function for individual month.
Attached is the screenshot for reference.
Kindly help!
Regards,
Aatish