DATEADD("year", -1, [start date]) will give you the previous year of your parameter.
I dont need last year , i need the same period For last year , As I explained above
He is actually right ... why can't you use:
[Date order]>=[start date new] and [Date order ]<=[end date new]
where start date new is what Wim proposed ..
By doing as Will said, you'll get the start date of the previous year, you have to do the same for the end date of previous year. And so by doing a calculated field Previous Year:
[Date Order] >= DATEADD("year", -1, [start date]) AND [Date Order] <= DATEADD("year", -1, [end date])
You'll get orders of the same range for previous year.
If you want the sum of sales for previous year, same range:
SUM(IIF( [Previous Year], [Sales], 0))
Okey, it works correctly
ok sir, thank you !