Good day!
Please help)
I want to create a flag that will help us analyze the period in last year.
For example, today week №13, Thursday, 27 , the data relevant to the 26.
Need to analyze the period in last year starting on week №13, Thursday and 26 days ago.
This year, I analyze the MTD (1.03.14-26.03.14)
In the previous year - MTD PY (2.03.13-27.03.13)
While working with the formula;
SUM ({<Date = {"> = $ (= Date (MonthStart (Today () -1, -12) +1)) <= $ (= Date (AddYears (Today () -1, -1) +1)) "}>} Sales).
But I need to upgrate formula. On the last day of the month formula should capture all MTD PY
I mean, when our report will be actual to 31 March 2014, the previous year we should take the period 1 -31 March.
During the month analyze the period via SUM ({<Date = {"> = $ (= Date (MonthStart (Today () -1, -12) +1)) <= $ (= Date (AddYears (Today () -1, -1) +1)) "}>} Sales).
How to do it?
Thank you very much.
