Current vs previous sales

[geogou1973]

Hello.

I'm looking for days a formula with set analysis, when i select the day of the current year to show me in a chart the current selected day sales and the previous day sales (-364 days)
For example if i select 23/10/2013 to shows me the sales for 23/10/2013 and the sales for 24/10/2012.

I can't find anything. Can someone help me with this problem?

I have an attach file below.

Thank you in advance.

[mdmukramali · Accepted solution]

Dear,

Kindly find the attachment.

Thanks,

Mukram.

[rustyfishbones]

Try

Sum({< DATE = {'$(=DATE(Today()))', '$(=DATE(AddYears(Today(), -1)))'} >} SALES)

[geogou1973]

Thank you very much.

It was so simple with the variable.

[geogou1973]

Dear Mohammed i try to apply this formula to compare the current and the previous sales by giving the year and the month but i don't have a result for the previous.

I create a variable for the previous year    vPreviousYear=max(YEAR)-1

and in set analysis i write the following:

=Sum({<YEAR={'$(vPreviousYear)'},MONTH=>}sales)

What i do wrong.

Can you help me ?