Calculation of rate based upon previous records

[AbhijitBansode]

I've currently come across the requirement of getting average of previous term amount based on the current month or quarter or term.

Please find the attached excel file for more dateils..

[spsrk_84]

Hi ,

i have gone throught the excel file but i want to know how should be your report format...

Regards,

Ajay

[AbhijitBansode]

Report format should be Like below:

Time	200910	200911	200912	201001	201002
Product
1	2%	4%	6%	8%	10%
2	7%	12%	17%	22%	27%
3	16%	2%	12%	23%	26%

I've shown above format using dummy values... these are not the actual claculations values..