Select last month and then three months after that in variabes

[Anonymous]

Hi Guys,

My monthly reports report on previous month, so i need a variable to pick up the last month and then combined last three months.  My fields for Year and Month are set up like below.  So for current report i'll need Sales Month 12,11,10 and Sales year 2015.

Thanks for your help guys

Sales Year	Sales Month
2015	1
2015	2
2015	3
2015	4
2015	5
2015	6
2015	7
2015	8
2015	9
2015	10
2015	11
2015	12
2016	1

[reddy-s]

Hi Lak,

I can see that you are trying to create a master calendar:

Follow this and this should solve your issue:

Creating A Master Calendar

Thanks,

Sangram.