Comparaison between Year N / N-1 for a given day

[#1]

Hi there ! The title isn't really clear, my bad !

I've got a problem : the point is to compare two years. So to do it, I want to create two tab charts, the first one is the situation for the last year. The second one, for the current year.

But the problem is that I want to compare at a given day, I'll show you by an exemple :

ID	Sum between 01/01/2013 - 28/04/2013
1	10 000 €

ID	Sum between 01/01/2014 - 28/04/2014
1	15 000€

I don't know how to do to sum(Total) for this period : how to sum from the beginning to a given day ? And in an other chart, for the last year ?

I've got the variables Year, Month, Day.

Thanks a lot !

[its_anandrjs]

Write like

For First Chart current year

Dimension:- ID

Current Expression:- =SUM({$<DateField = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}Sales)

For Second Chart previous year

Dimension:- ID

Expression:- =SUM({$<DateField = {'>=$(=AddMonths( YearStart (Today()),-12))<=$(=AddMonths( MonthEnd (Today()),-12))'}>}Sales)

[MK_QSL]

What do you mean by a GIVEN DAY?

Is it a Date Field or until Today()