year to date

[#1]

Hi,

Doing stuff on the YTD. Please look at the rightmost chart in the attachment. Here I want to display the date from the current year and not the date from the last year, though I want to display the figures from the previous year.

If you look at the rightmost chart in the attached file the chart displays 03/07/2013 and 10/07/2013 as the dates from the current year.

The chart now displays 4 rows where I expect to see only 2 rows as follows. i.e. I need to display the dates only from the current year.

DateF          Year          Month     Week     Day     Current            Previous

03/07/2013  2013-2014     1          1-1          1          720               220

10/07/2013  2013-2014	2	2-2	1	410                60

Thanks,

Ram

[tresB]

Your previous year data is for some other dates and you want to show them against other dates, how is this logical? I guess, your date field is not relevant here.

[#3]

Hi, The relevance is not based on the dates. It is based on the Month + Week + Day combination. A date this year points to a different date last year based on that combination.

Thanks,

Ram

[#4]

09/07/2012,2012-2013,2,2-2,1,29

09/07/2012,2012-2013,2,2-2,1,31

10/07/2013,2013-2014,2,2-2,1,80

10/07/2013,2013-2014,2,2-2,1,350

Here, 10-Jul-2013 this year is 430. The same day last year is 09-Jul-2012 and 60. That is by matching Month(2), Week(2-2) and Day(1).