How to see previous YTD values using set analysis and automatically taking into selection for the previous year not selected periods and days but associated in the current year
Dear QVCommunity,
I can't find a way to show previous year amounts based automatically only on the year selection. For example, if I select a year and have Jan-Mar data in current year I would like to show amounts for the previous year only for Jan - Mar, without extra selecting periods and days.
I appreciate your time. It is okay for today and 2013 vs. 2012, but when I select 2012 then I get 372380 for 2011 instead of 374210. This is because you used the system date, today(), so Dec 2011 is excluded and it should be included because 2012 has all 12 months.
Yes, old years are now fine but now the first case is not. I get 545780 for 2012 which is a fully year sale and in the beginning of this exercise you got 487680 which is what I would like to get if possible.
Thx