I am trying to produce a report that compares corresponding periods within a date range parameter. Currently, I run the report each week and would like to have the new report make the following comparisons:
Right now, I am using running totals with the formulas below.
Current year: {@Formula} in ["Type"] and (Year({date.field})=Year(CurrentDateTime))
Previous year:{@Formula} in ["Type"] and ({date.field} in LastYearYTD)
I have also set up a similar LastYearMTD formula for the month-to-month comparison. The problem I'm having is that the end dates are determined by the current date with the YTD function rather than over the date range I've entered into the parameter. So when trying to compare the period of 1/1/2018-6/10/2018 to the same period in 2017, it is currently comparing it to 1/1/2017-6/19/2017.