Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i want the calendar to select two range of dates to compare them for sales
but in the sheet i keep getting same data for the overall for last year and this year
and 0 for last year in month to date
i want a fix for this so i can select two (range ) dates like a holiday week in apr 2022 and holiday week in apr 2023
( have this for date in data load )
date(Date#(Date,'DD-MMM-YYYY')) as Date,Year,
Month,
Day,
DateNum,
First date range
Sum({<Date = {">=$(vStartDate1)<=$(vEndDate1)"}>} Sales)
second date range
Sum({<Date = {">=$(vStartDate2)<=$(vEndDate2)"}>} Sales)
hello thanks for the reply ,
how can i use this in date picker( calendar )