This is my first time posting here, I hope someone will be able to point me in the right direction for my particular problem.

I have to write a report for my boss, details as follows

 

We are reporting on Sales and Customers by Date and by store,

I already have grouped by both store and date (monthly totals).

I need to create a trailing 12 month total for each store for each month, which should consist of that months sales plus the previous 11 months.  I have no idea how to proceed with this.

 

Any help would be appreciated.

 

Thanks

 

Noreen

 

Store Sales by Month
05/11/08
Store
			TY Sales	LY Sales	% Change	Trailing 12 Months
01/06	Store Name		29,490	26,374	11.82%	??
02/06	Store Name		27,812	24,795	12.17%	??
03/06	Store Name		31,272	33,364	(6.27%)	??
04/06	Store Name		42,415	34,783	21.94%	??
05/06	Store Name		33,624	28,988	15.99%	??
06/06	Store Name		36,883	37,917	(2.73%)	??
07/06	Store Name		40,340	41,712	(3.29%)	??
08/06	Store Name		40,758	42,362	(3.79%)	??
09/06	Store Name		33,770	31,730	6.43%	??
10/06	Store Name		33,932	32,116	5.65%	??
11/06	Store Name		30,980	30,267	2.36%	??
12/06	Store Name		41,789	44,229	(5.52%)	??
01/07	Store Name		29,363	27,781	5.69%	??
02/07	Store Name		26,599	27,745	(4.13%)	??
03/07	Store Name		35,582	33,689	5.62%	??
04/07	Store Name		38,790	41,100	(5.62%)	??
05/07	Store Name		40,009	33,208	20.48%	??
06/07	Store Name		40,016	37,704	6.13%	??

 

 

 

Does this data help?  I also realise that you need 11 months data before the date range you need to report on.

 

 

Noreen