Creating an automatic sales report. We are comparing current year MTD sales vs. last year same time period. (Day period level)
MTD Sales Ex: March 1, 2023 -> March 8th, 2023 = Total of $4,350 in Sales
MTD sales (this will update automatically as the next day comes)
I’m trying to figure out the correct syntax to get the same time period for last year same Month, relative to current day.
Relative Month to current day last year Ex: March 1, 2022 -> March 8, 2022 = Sales ???
I’ve tried =[PY Gross Sales] Where [Billing Date] Between ([Prev. Year MTD Start Date];RelativeDate(CurrentDate();-365))
[PY Gross Sales] - available dimension
[Billing Date] - available dimension
[prev. Year MTD Start Date] - available dimension.
I received a #Multiple Vaules Errors & #Datasync Errors. Trying a few different variations.
I have not had any luck trying a few different functions: If function, dates between, RelativeValue. I’m missing something here and could use your help. Any help is appreciated.
