Compare Sales for Same DAY Last Year

[CB308]

The end user wants to compare sales by DATE for the same date last year.

In the example below, 01/01/2010 Sales are $304,304, the sales listed in Same Day Last Year are for the date (01/02/2009)

Currently I am only showing sales by actual date 01/01/2010 and 01/02/2009 but not next to each other as the end user is looking for...

Any suggestions?

Week #	Day of Week	Date	Sales	Sales Same Day Last Year
1	Friday	1/1/2010	$304,304	$328,120

my results:

Week #	Day of Week	Date	Sales	Sales Same Day Last Year
1	Friday	1/1/2010	$304,034
		1/2/2009	$328,120
	Saturday	1/2/2010	$475,357
		1/3/2009	$338,492

[#2]

Hi,

I have the same problem but i need it in backend ,means in script.I want to compare sales of this year to previous year but for the same day of previous year.

Thanks in advance,

Rathish

[#3]

Looking back at these, they both worked for me. And I got the correct values for the one day. Now is there a way to create a rollup like this? I want to compare each day for the 12 months (365 days) to the previous 12-24 months, 365-730.

Any ideas how I would do that?

[sravan_v007]

Hi Friends,

I think this will help you...

It contains diffrent YTD calculations using Set Analysis....