5 Replies Latest reply: Oct 25, 2013 7:21 AM by Rajkumar Maurya

# compare sales current vs previous

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.

• ###### Re: compare sales current vs previous

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,

• ###### Re: compare sales current vs previous

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 ?

• ###### Re: compare sales current vs previous

Hi

use this expression

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

• ###### Re: compare sales current vs previous

Use this one...