compare sales current vs previous

[geogou1973]

Hello.

How can i compare the current sales vs previous sales giving only the current year date in the selections and the chart giving me also the previous sale date in the same period and in the same weekday. Also if i give the month compare automatically the sales in the previous year. Is there any set analysis to do this ?

Below i have a sample.

Thank you in advance.

[#2]

Hi,

Have a look at attached QVW, and let me know you got what you want ?

Or let me what you want in detail.

Thanks,

[geogou1973]

It is very usefull but when i give 23/10/2013 current sales and the week day is WED i want to compare with the 24/10/2012 that is also WED.

How can i do this ?

[#4]

Hi

use this expression

sum({<YEAR={$(=only(YEAR)-1)},MONTH={$(=max(MONTH))},WEEK_DAY={"$(=only(WEEK_DAY))"},DATE= >}SALES)

[#5]

Hi hope it will help u

[#6]

  Use this one...

Sum({$<DATE={">=$(=addmonths(Today(),-12)+1) <=$(=addmonths(Today(),-12)+1)"}>} SALES)